AutoFill
 

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.

AutoFill
 

Alright, this was pretty fun... try this.

Go to

Tools-- Macro --- Visual Basic Editor

The in the Visual Basic Editor go to

Insert --- Module

Then Copy and paste this exactly as is, in to the module

Sub cols()
For x = 1 To 26

ActiveCell.Formula = "=LEFT(ADDRESS(1," & x & ",2),1)"
ActiveCell.Offset(1, 0).Activate

Next x

For x = 27 To Columns.Count
ActiveCell.Formula = "=LEFT(ADDRESS(1," & x & ",2),2)"
ActiveCell.Offset(1, 0).Activate
Next x

End Sub

Then select the cell where you want the columns letters to start. So the
cell where you want A. Then go to

Tools--- Macro--- Macros

And then click on the macro colled "cols" and then press play and watch the
magic!

"carl" wrote:

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.

AutoFill
 

Bit of a mouthful but this works
=LEFT(ADDRESS(ROW(A1),ROW(),2),FIND("$",ADDRESS(RO W(A1),ROW(),2))-1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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.

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.