VBA Code

[Frimpage]

In one of your video on YouTube, ( Excel - generating all possible lottery Combination in excel)
I want to have the code you used for the tutorials.
Please can you help me to get it?

 

[Joe4]

Welcome to the Board!

Is this what you are looking for here (note the code in the first post)?

Excel List All Lottery Combinations - 2441

Reid would like to list all 6-number combinations of the numbers 1 to 44. For example, 1-2-3-4-5-6, 1-2-3-4-5-7, and so on up to 39-40-41-42-43-44. The first thing to realize is that all lottery combinations are a lot of numbers. Over 7 million possibilities according to the COMBIN function in...

www.mrexcel.com

If you have any questions about it, it is best to post them right in that thread.

 

[Frimpage]

Thank you very much... it works exactly as you taught us on youtube...

i want to also ask if the numbers i want to work with are random numbers, but hasnt been arranged in order?
How should i update the VBA code?

 

[Joe4]

I did not create that, MrExcel himself (Bill Jelen) did.

As I said in my last reply, it is best to post your questions about that right in that thread itself (the one I provided the link you). You can see that there are lots of questions and answers on it.

If you post it there, Bill Jelen and everyone who posted to that article will see your question, and it stand a much better chance of being answered (much better than posting to a new separate thread that has no relation to the original video).