How to retrieve Excel column as a string (AAA instead of 703)

[Guest]

Hello

I was using GetProperty to retrieve the column on an Excel spreadsheet, but
it returns me the number of column ..

Is there a way I get the corresponding column name, I mean using the letters
instead of the number? (like getting AAA instead of 703, or ZZ instead of
702).

 

[Ron de Bruin]

Hi Aggie

You can use this function from Chip Pearson

Function ColumnLetter(R As Range) As String
ColumnLetter = Left(R.Address(False, False), _
1 - (R.Column > 26) - (R.Column > 702))
End Function