Recognizing column name

[ilyaskazi]

i want vba code to know on which column my cell is active

i.e. whether it is on colomn A or XYZ.

[Killian]

This will do it...

Dim a as String
a = ActiveCell.Address
MsgBox Left(Right(a, Len(a) - 1), InStr(Right(a, Len(a) - 1), "$") - 1)

[ilyaskazi]

its good,

thanku killian...