View Full Version : [SOLVED:] Recognizing column name
ilyaskazi
04-01-2005, 12:34 AM
i want vba code to know on which column my cell is active
i.e. whether it is on colomn A or XYZ.
Killian
04-01-2005, 01:38 AM
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
04-01-2005, 08:31 PM
its good,
thanku killian...:thumb
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.