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
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
Title | # Comments | Views | Activity |
---|---|---|---|
VBA to look in every sheet and | 2 | 22 | |
How to Auto-fill data in Database | 2 | 19 | |
Copy the formula in excel | 8 | 28 | |
Add macros on Open | 9 | 32 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!