get Column Letter

[Djblois]

I know how to get the column number of the activecell but how do I get the column letter? is that possible?

[mdmackillop]

Have a look at this KB item (http://www.vbaexpress.com/kb/getarticle.php?kb_id=218)

[MikeO]

ColLetter = Mid(ActiveCell.Address, 2, InStrRev(ActiveCell.Address, "$") - 2)


Someone may know an easier way.

[tstav]

How easier can it be MikeO than the one you provided? :thumb
This is just a teeny-tiny variation (in case anyone was caught by surprise with the instrrev)
Mid(ActiveCell.Address, 2, InStr(2, ActiveCell.Address, "$") - 2)

[RichardSchollar]

Another option:

ColumnLetter = split(Activecell.address(true,false),"$")(0)

Richard

[tstav]

Great idea Richard!!
colLetter = Split(ActiveCell.Address, "$")(1)

[rory]

Why do you want it as a matter of interest?