Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Algorithm to convert Column Letter to Number
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Algorithm to convert Column Letter to Number
Hi Fred,
Try: m = Columns("AB").Column --- Regards, Norman "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Algorithm to convert Column Letter to Number
Columns("AB").Column ? -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Fred Holmes wrote : 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Algorithm to convert Column Letter to Number
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |