View Single Post
  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default

You need a macro to do this. E.g.,

Sub AAA()

Dim Ndx1 As Integer
Dim Ndx2 As Integer
Dim Ndx3 As Integer
Dim Dest As Range
Set Dest = Range("A1")

For Ndx1 = Asc("A") To Asc("Z")
For Ndx2 = Asc("A") To Asc("Z")
For Ndx3 = Asc("A") To Asc("Z")
Dest.Value = Chr(Ndx1) & Chr(Ndx2) & Chr(Ndx3)
Set Dest = Dest(2, 1)
Next Ndx3
Next Ndx2
Next Ndx1
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"dogisnuts" wrote in
message
...
I want excel to auttofill an alphabetic sequence. AAA, AAB,
AAC, etc. all
the way to ZZZ.