View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
seagee69 seagee69 is offline
external usenet poster
 
Posts: 2
Default Every 5 digit combination

As a newby to Excel VBA, I'd like to create a spreadsheet that would
give me every 5-digit combination of the numbers {1, 3, 5, 7, 9} in one
spreadsheet. The numbers can repeat.

I thought of the FOR NEXT loop, but I am not sure how to get the output
to the next row, nor am I certain it would give every combination.

Thanks so much,

seagee69