View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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