Algorithm to convert Column Letter to Number

  • Thread starter Thread starter Fred Holmes
  • Start date Start date
F

Fred Holmes

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
 
If A1 held the string "AB", perhaps something like this...

=COLUMN(INDIRECT(A1&"1"))

returns 28
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

best way to express the range "column N to column M"? 7
Convert Date-as-Text 3
Column Designation Conversion - alpha/numerical 1
Convert Column letter designation to a number 6
convert letters to numbers 3
Excel columns: Converting numbers to letters and vice versa 14
Sum work hours to hours & nearest 10th of an hour 14
Runtime error 1004 when trying to insert formula in cells 11

Back
Top