Returning Column of active cell

[Marek]

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

[Tom Ogilvy]

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" <Marek@discussions.microsoft.com> wrote in message
news:25B22099-503F-433B-BA2C-6154DC57BC58@microsoft.com...
> 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