AutoFill

[Guest]

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.

 

[Guest]

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!

 

[Bernard Liengme]

Bit of a mouthful but this works
=LEFT(ADDRESS(ROW(A1),ROW(),2),FIND("$",ADDRESS(ROW(A1),ROW(),2))-1)
best wishes

 

[T. Valko]

Try this:

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

Copy down as needed

Biff