Get column letter

[agibsonsw]

Hello again. Excel 2003

If I have a column number e.g. 4, is there an Excel method to convert this to the letter "D", or do I need
to add 4 to chr(65)-1? Thanks, Andy.

[HansV]

I assume you want to do this in VBA.

Let's say the column number is stored in a variable n.

Code: Select all

Dim n As Long
Dim strAddress As String
Dim p As Long
Dim strColumn As String

n = ...
strAddress = Cells(1, n).Address(RowAbsolute:=True, ColumnAbsolute:=False)
p = InStr(strAddress, "$")
strColumn = Left(strAddress, p - 1)

This will work whether the column has one letter (as for column D) or two (as for column DF) or even three (in Excel 2007 or higher, e.g. column DFG).

[agibsonsw]

Thanks again.