Use VBA to Return Column Letter / Not Number

[michaeldh]

Hi,

I was hoping to find a solution to the following:

Activesheet.column

Returns a column number, how can I return just the letter. I know you can do Activesheet.address but I just want the letter only without having to strip it out etc.

Any ideas?

Thanks.

 

[Krishnakumar]

Hi,

MsgBox Replace(Cells(1, ActiveCell.Column).Address(0, 0), 1, "")

HTH

 

[northwolves]

An easier one:

MsgBox Split(ActiveCell.Address, "$")(1)

 

[michaeldh]

Perfect!

Thanks so much.