View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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