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

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

--
thanks so much.

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

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Aggie" wrote in message ...
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).

--
thanks so much.