Get Column Letter

  • Thread starter Thread starter BB Ivan
  • Start date Start date
B

BB Ivan

In a procedure, how can I get the letter of a referenced column rather than
it's number?
 
Thanks. I was hoping there was a property not listed in the Help Files, but
this works great.
 
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
 
Only works up to column Z.
Click to expand...

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
Columns now numbers rather than letters how do i get letters back 2
Creating sequential numbers plus a letter 4
Change Excel column headers from numbers to letters 1
Columns are Numbers 5
How do I convert numbered columns to lettered columns? 1
How to type each letter of the alphabet automatically in a specific color in Word? 0
Letter and space count in cell 1

Back
Top