#Past mega numbers 2022 code

ThisColumn = 1 ' Initialize 1st column to display results in MaxRows = 1048576 ' Set to maximum number of slots in Array MaxWhiteBallValue = 70 ' <- Set to highest value of white ballĪrraySlotCount = 0 ' Initialize ArraySlotCountĬombinationCounter = 1 ' Initialize CombinationCounter

#Past mega numbers 2022 code

By the way I did try the code that mr excel put in the first post but computer never finishes its been like one 3 days straight and only at about 30 million combinations but it works and prints the way it should.ĭim Ball_1 As Long, Ball_2 As Long, Ball_3 As Long, Ball_4 As Long, Ball_5 As Long, Ball_6 As Longĭim CombinationsArray(1 To 1048576) As Variant Can you or anyone help me on this issue, I'm new to programming and doing this just to have the entire combination's list. So I then changed parameters on the code on combinationsArray to 65536 how your original code was and max combinations it goes to is 280,500,000 where total should be the 302,575,350 possibilities, unless I'm mistaken. First thing is it will not print combinations past the 65,536 cell, after that it displays #N/A on every cell all the way to 1,048,576 then on column B1 combinations continue where 1,048,576 should of left off. So JohnnyL, after using your first code and modifying just a few things to work with mega millions I got some issues. Title of that thread was Excel List All Lottery Combinations-2441. So i was advised by JohnnyL at thread 2441 to post a new thread so here it is. Well honestly, Why not? Once i have them, later on in the near future i will be implementing some type of number analysis with that list and the already drawn numbers from past history.

Yes i know what your thinking But WHYYYYYYYYYYYYYYYYYYYY? Theres over 300 million combinations. I was following a thread about mrexcel and running a script to generate into excel all possible combinations of US mega millions lottery.