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

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