3-character combinations?
Probably other ways, but here's one:
- Place A-Z in A1 to A26
- Place 0-9 in A27 to A36
Then you can use this code.
Sub test()
For cOne = 1 To 36
myCell1 = Range("A" & cOne).Value
For cTwo = 1 To 36
myCell2 = myCell1 & Range("A" & cTwo).Value
For cThree = 1 To 36
myCell3 = myCell2 & Range("A" & cThree).Value
Range("B" & Range("B65536").End(xlUp).Row + 1).Value = myCell3
Next cThree
Next cTwo
Next cOne
End Sub
HTH,
Paul
--
"Allison" wrote in message
...
Excel 2003 SP3
Win XP SP2
Is there a quick way to generate a list of all possible 3-character
combinations using the alpha characters A-Z and the numbers 0-9?
|