Please help to.modify the code to Possible 7/1-49 Lottery Number Combinations

Dear all expert

Does anyone can know how to generate all lotto 7/49 combinations ? i saw many website, still cannot find the vba code, the most closest one is

Please Login or Register  to view this content.

Does any expert can vary this to All Possible 7/1-49 Lottery Number Combinations. The total is 13983816 combination. Thank you very much.

Thanks in advance,
Isaac

There are more efficient techniques than this, but your sample code is easily fixed by merely changing the numbers at the end of FOR statements.

Please Login or Register  to view this content.

Ok, here is how I would list all the possible selection of 7 numbers from 1-49. Your post #1 indicates you expect 13million results, and that is far too low. I ran this macro and stopped it at 49million and growing. So, even with this technique, it will take a while.

Your original macro was actually writing out each combination to the worksheet one at a time. That will take forever. This method builds a list of 65000 results in memory, then writes them all out at once. Then repeats. So even with 100s of millions of results it will be 65000 times faster.

Also, your original macro limited to 65k rows I presume to maintain Excel 2003 compatibility, but your macro would run out of columns pretty fast. This new version will keep adding sheets as needed until it is done.

Please Login or Register  to view this content.

It didn't start there. You are just looking at the LAST sheet created when it was finished. Go back to the first sheet in the workbook to see the first numbers. They are all there.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Same edit as before. The LAST inner FOR loop hold the highest number. Each loop working up from there reduces by 1. Then the lowest number is listed in the first FOR loop.

Please Login or Register  to view this content.