Thread: Convert Column letter designation to a number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
  
Posts: 97
Default Convert Column letter designation to a number
http://www.vba-programmer.com/Snippe...tr_To_Num.html


"Fred Holmes" wrote in message
...
Is there a code statement that will convert the letter designation of
a column to a number, e.g., convert "A" to "1" and and so forth using
the letter pattern used to designate columns in a worksheed?

"AA" would be converted to "27".

I need to do arithmetic using the column numbers.

Thanks,

Fred Holmes


Reply With QuoteReply With Quote