Thread: AutoFill
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default AutoFill

Try this:

=SUBSTITUTE(ADDRESS(1,ROWS($1:1),4),1,"")

Copy down as needed

Biff

"carl" wrote in message
...
I am trying to make a list like this:

A
B
C
.
.
Z
AA
AB

etc.

A Column List of all the Col's in a worksheet.

Is this possible ?

Thank you in advance.