B
BB Ivan
In a procedure, how can I get the letter of a referenced column rather than
it's number?
it's number?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
=MID(ADDRESS(1,COLUMN()),2,LEN(ADDRESS(1,COLUMN()))-3)
B
BB Ivan
Thanks. I was hoping there was a property not listed in the Help Files, but
this works great.
this works great.
G
Gord Dibben
In a procedure, call this function.
Function GetColLet(ColNumber As Integer) As String
GetColLet = Left(Cells(1, ColNumber).Address(False, False), _
1 - (ColNumber > 26))
End Function
Sub test()
MsgBox "this is column " & GetColLet(ActiveCell.Column)
End Sub
Gord Dibben MS Excel MVP
Function GetColLet(ColNumber As Integer) As String
GetColLet = Left(Cells(1, ColNumber).Address(False, False), _
1 - (ColNumber > 26))
End Function
Sub test()
MsgBox "this is column " & GetColLet(ActiveCell.Column)
End Sub
Gord Dibben MS Excel MVP
M
MyVeryOwnSelf
In a procedure, how can I get the letter of a referenced column rather
One way:
=CHAR(COLUMN(A1)+64)
than it's number?
One way:
=CHAR(COLUMN(A1)+64)
P
Pete_UK
M
MyVeryOwnSelf
Only works up to column Z.
Right... my bad.
(I cancelled the article after posting it, but apparently it escaped into
the world anyhow. Next time, I'll post a retraction too.)
P
Pete_UK
No problem - in many situations that's more than enough.
Pete
Pete