Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If A1 held the string "AB", perhaps something like this...
=COLUMN(INDIRECT(A1&"1")) returns 28 HTH -- Dana DeLouis Win XP & Office 2003 "Fred Holmes" wrote in message ... Is there a VBA function or algorithm readily availble that will convert the column letter designation to the column number (such as is used in Cells(n, m))?? For example, looing for an F() such that: m = F("AB") would return m = 28 thanks in advance, Fred Holmes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column Header - Convert a Number to a letter | Excel Discussion (Misc queries) | |||
Convert a letter to a number | Excel Discussion (Misc queries) | |||
How do I convert a given number into a letter? | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |