View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark[_48_] Mark[_48_] is offline
external usenet poster
 
Posts: 2
Default How to cycle all possible permutations

I want to try every combination of 10 numbers out of 1 to 64 (I reckon
there are about 1,300 odd but that is just my intuitive guess rather
than any mathematical knowledge.

I should think there is a for...next loop over a few layers that would
do it but I cannot for the life of me figure it out not having a maths
background. Can anyone help me out?

Kind regards, mark