Check out these old posts.
The first describes how to set-up A to Z.
The second describes how to go beyond Z, to AA, AB, AC ... to maybe SA, SB,
SC ... etc.
http://groups.google.com/group/micro...5911fc66478752
http://groups.google.com/group/micro...8a0b7118ec0725
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"oldLearner57" wrote in message
...
10s! :) Jarek Kujawa much appreciated
thanks community as well :)
--
oldLearner57
"Jarek Kujawa" wrote:
in A1:
=CHAR(ROW()+96)
then copy down