How to know the actual column?

C

Casrlos A.

Hi I need i know the actual column.
e.g. I fill the cell B(any row) and I need retrieve the value "B"
For the moment I'm using a button to retrieve this data.

Thanks a lot.
(Excel 2003)
 
B

Bob Phillips

msgbox Split(Columns(activecell.Column).Address(, False), ":")(1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top