convert culomn letter from number
Hi All,
I'm trying to convert or to find a way to get the column letter from its column number index for the range use with vba any ideas? |
convert culomn letter from number
'----------------------------------------------------------------- Function ColumnLetter(Col As Long) '----------------------------------------------------------------- Dim sColumn As String On Error Resume Next sColumn = Split(Columns(Col).Address(, False), ":")(1) On Error GoTo 0 ColumnLetter = sColumn End Function -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "thread" wrote in message oups.com... Hi All, I'm trying to convert or to find a way to get the column letter from its column number index for the range use with vba any ideas? |
All times are GMT +1. The time now is 09:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com