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

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

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

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