# Column() convert to letter (A1 notation)

#### John Kauffman

##### New Member
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())

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### Scott R

##### Active Member
MsgBOx("active column is " & activecell.address)

#### John Kauffman

##### New Member
Scott:
Thanks for quick response.

The question is how to get only the column address in A1 notation.
I'm comfortable getting the entire address with either:
or

Thanks, John

#### Ver101

##### Board Regular
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())

You can use the Cell function ("address") changing all (find and replace function) except the A1 notation

#### Ver101

##### Board Regular

You can use the Cell function ("address") changing all (find and replace function) except the A1 notation

You can also used Address function removing excess through find and replace

#### JoeMo

##### MrExcel MVP
Try this:
Code:
With ActiveCell
For i = 1 To Len(Adr)
Next i
End With
MsgBox "Activecell is in column " & Mid(cAdr, 2, Len(cAdr) - 2)
End Sub

#### pgc01

##### MrExcel MVP

Hi John

You can get the column in A1 notation, but why do you want to do it?

Code:

#### John Kauffman

##### New Member
Thanks to both.
MoJoe - I was headed down your route; thanks for working code to which I can compare my parsing / conversion.
Pgc - brilliant & you introduced me to a whole new function

Will be used to report to user the col that has changed.

#### pgc01

##### MrExcel MVP
I'm glad it helped. Thanks for the feedback.

Will be used to report to user the col that has changed.

I was wondering why you needed it as it is not needed in vba. Thanks.

Replies
11
Views
91
Replies
3
Views
193
Replies
6
Views
100
Replies
0
Views
61
Replies
11
Views
293