Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Letter to Number | Excel Worksheet Functions | |||
Convert a letter to a number | Excel Discussion (Misc queries) | |||
convert column number to letter | Excel Programming | |||
convert column number to letter | Excel Programming | |||
How do I convert a given number into a letter? | Excel Worksheet Functions |