Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
Autofill until | Excel Discussion (Misc queries) | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) |