List all combinations from 1 to 45

Hi,

This about an exercise, we need to visualize all possible combinations for a lottery.

The question is:

Can somebody make a VBA code which writes down all possible 6-combinations from 1 to 45.

But i would like to add a colour. And these folowing colours for each number combination.
1 rood
2 geel
3 groen
4 blauw
5 oranje
6 paars

It should be around the 40.000.000 combinations.
I added an excel sheet to give an example. But it is to much to do by hand.

Thnx

Just to add: if one combination takes only 1 ms that's 40.000 seconds - more than 11 hours

Hi,

I think this would be the code for numbers, but i need to add the colors to each combination.

Please Login or Register  to view this content.

Can somebody add this in this VBA code.