(adsbygoogle = window.adsbygoogle || []).push({}); ok so i have my code for permutation
but excel 2007 has a limit of how many coloumns you use
i would like to add to my code that if it gets to the end of the sheet it goes onto the next one

here is my code:
Sub permutation()
Count = 1
For a = 1 To 26
For b = 1 To 26
For c = 1 To 26
For d = 1 To 26
For e = 1 To 26
Cells(Count, 1) = Chr(96 + a) & Chr(96 + b) & Chr(96 + c) & Chr(96 + d) & Chr(96 + e)
Next
Next
Next
Next
Next
End Sub

Use Text edit

---------- Post added at 03:48 PM ---------- Previous post was at 03:48 PM ----------

or notepad

im no good at this stuff

Do you know any other ways to get all the permutations of the alphabet to 29 strings?

like i said b4 man, i dunno