View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Generating a list of all possible number/letter combinations

Sub tester1()
Dim i As Long, j As Long
Dim k As Long, ii As Long
Dim varr(1 To 36) As String
For i = 1 To 10
varr(i) = i - 1
Next
j = 11
For i = 65 To 90
varr(i - 54) = Chr(i)
Next i
ii = 0
For i = 1 To 36
For j = 1 To 36
For k = 1 To 36
ii = ii + 1
Cells(ii, 1).Value = "'" & varr(i) & _
varr(j) & varr(k)
Next
Next
Next
End Sub

--
Regards,
Tom Ogilvy


orion wrote in message
...
I have to generate a list of all possible letter/number combinations of
the form _ _ _. There are no restrictions, it can start with a letter,
or a number, have no numbers (AAA), or no letters (000). Any ideas on
how to do this in excel or using VBA?


---
Message posted from http://www.ExcelForum.com/