If you really want the column letter, I think the best way is to use the column index property relative to the ASCII character code. Cap A is 65 so:[VBA]MsgBox Chr(ActiveCell.Column + 64)[/VBA]
If you really want the column letter, I think the best way is to use the column index property relative to the ASCII character code. Cap A is 65 so:[VBA]MsgBox Chr(ActiveCell.Column + 64)[/VBA]
K :-)
Posting Permissions
Reply With Quote