Return Column Alphabets from Number

[kpark91]

Hello, is there a function in Excel VBA that returns
alphabet representation of column number?

For example,
1 = "A"
26 = "Z"
27 = "AA"

Thank you in advance,
Kpark

 

[kpark91]

I found it.

MyColumnLetter = Left(Cells(1, 45).Address(1, 0), InStr(1, Cells(1, 45).Address(1, 0), "$") - 1)

 

[mikerickson]

Try

columnLetter =Replace(Cells(1, columnNumber).Address(False, False, xlA1, False), "1", vbNullString)

 

[kpark91]

Awesome. thank you :P

 

[Jonmo1]

Just a note....

You can use column NUMBERS in VBA..
There's no need to convert them to letters..

Use Cells instead of Range
Cells(Row#, Column Number OR Letter)

Range("A1")
Same as
Cells(1,1)
Same as
Cells(1,"A")


Hope that helps.

 

[mirabeau]

mycolumnletter = Split(Cells(1, 45).Address, "$")(1)