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
|