John Kauffman
New Member
- Joined
- Oct 13, 2011
- Messages
- 23
Is there a way to get the column letter (in A1 notation) of the active cell, as opposed to its number (from R1C1 notation).
=ADDRESS(5,10,4 ) returns row and col in A1 notation, but getting just col is a parse job
My sources of column number (R1C1)
Formula: =Column()
Code: MsgBOx("active column is " & activecell.column())
=ADDRESS(5,10,4 ) returns row and col in A1 notation, but getting just col is a parse job
My sources of column number (R1C1)
Formula: =Column()
Code: MsgBOx("active column is " & activecell.column())