Friday, November 9, 2012

Get Column heading/name of selected cell through VBA (Excel)

In VBA, For getting the column heading/name of a selected cell  i.e. Column "A" or Column "B" use below code in macro.

CurCol = Split(ActiveCell.Address, "$")(1)

No comments:

Post a Comment