| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column Headings
i = 27
colLetter = Left(cells(1,i).address(0,0),1-(cells(1,i).Column26)) -- Regards, Tom Ogilvy "OkieViking" wrote in message ... In VBA columns are denoted by numbers, but in Excel they are denoted by letters (i.e. Column A, Column C). Is there a Column property that returns the Letter instead of the number? Is there another way of getting to that? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column Headings
Thanks again!
"Tom Ogilvy" wrote: i = 27 colLetter = Left(cells(1,i).address(0,0),1-(cells(1,i).Column26)) -- Regards, Tom Ogilvy "OkieViking" wrote in message ... In VBA columns are denoted by numbers, but in Excel they are denoted by letters (i.e. Column A, Column C). Is there a Column property that returns the Letter instead of the number? Is there another way of getting to that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column Data to Appear as Column Headings in Another Sheet | Excel Discussion (Misc queries) | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
| How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Linear Mode
