Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
row = 1;
For i = 1 to 78
For j = i+1 to 79
For k = j +1to 80
Range("A"&row).Value = i
Range("B"&row).Value = j
Range("C"&row).Value = k
row = row + 1
next k
next j
next i
Now, what would be great would be a way of listing them all out in order.
1 2 3 (each number to its own cell)
1 2 4
1 2 5
1 2 6.... etc