| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning Column of active cell
Hi,
Does anyone know how to return the column of the active cell - not as a column number but the column letter. So, if cell C1 is selected, return column C. The Column propert seems only to return the number 3 -- Many thanks in advance for any assistance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Returning Column of active cell
colLetter = Left(ActiveCell.Address(0,0),1 - (ActiveCell.column 26))
Although, there is no need to do this if trying to reference a location. -- Regards, Tom Ogilvy "Marek" wrote in message ... Hi, Does anyone know how to return the column of the active cell - not as a column number but the column letter. So, if cell C1 is selected, return column C. The Column propert seems only to return the number 3 -- Many thanks in advance for any assistance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning value of active cell | Excel Worksheet Functions | |||
| Returning same value cell in a column but different row. | Excel Worksheet Functions | |||
| How to locate the Row and Column of an Active Cell | Excel Discussion (Misc queries) | |||
| Returning active cell | Excel Worksheet Functions | |||
| copying the column of the active cell to another column | Excel Programming | |||
Linear Mode
