Using Excel, I want to create a series of letters (e.g. AAA, AAB, AAC,...,ZZY, ZZZ), one per cell. Can this be done using Excel? I've tried working with the series functionality in Excel without any luck. And my knowledge of VB is extremely limited.
thanks,
Rob
Type your list up in any workbook; AAA through ZZZ.
Then select all 26 cells.
Hit Tools-Options, Data lists. Hit the Import list button.
k?
Dreamboat, I don't think I understand. I don't want to type the series (AAA, AAB,...ZZY,ZZZ) which would take all day. I want Excel to generate the series.
thanks
see if this helps : (my ameuter version)
<PRE>
Sub AAA_ZZZ()
o = 0
myA = 65
For q = 1 To 26
myB = 65
For p = 1 To 26
myC = 65
For t = 1 To 26
myCELL = Chr(myA) & Chr(myB) & Chr(myC)
Range("A1").Offset(o, 0).Value = myCELL
myC = myC + 1
o = o + 1
Next t
myB = myB + 1
Next p
myA = myA + 1
Next q
End Sub
</PRE>
pop it in a normal module and it should start at A1 and finish up at A17576
is this what you want ?
This i have been asked to post from Chris D
Code:
Sub AAA_ZZZ()
o = 0
myA = 65
For q = 1 To 26
myB = 65
For p = 1 To 26
myC = 65
For t = 1 To 26
myCELL = Chr(myA) & Chr(myB) & Chr(myC)
Range("A1").Offset(o, 0).Value = myCELL
myC = myC + 1
o = o + 1
Next t
myB = myB + 1
Next p
myA = myA + 1
Next q
End Sub
Worked like a charm. Thanks to all.
Hello. I know it was few years passed but maybe will answer me. I am totally green ( as we say in Poland) and I even do not know how to put this into excel. Maybe someone can show me that already in excel? I can not sleep without getting know how to make this AAA, AAB AAC stuff...
Welcome to the Forum
Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.
Don’t have an account yet? Register yourself now and be a part of our community!
