View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
jack jack is offline
external usenet poster
 
Posts: 97
Default Excel columns: Converting numbers to letters and vice versa

As usual I have made a mistake.

Excel column AA is not equal to 28
A1 --28
A2 -- 29
etc
Jack

"Jack" <replyto@it wrote in message
...
Hello,
My app is using Excel spreadsheet.
User has a choice of preselecting some of the sheet's columns.
Now:
Excel is using letters as the visual indexing, of the columns but when
programming the corresponding number (A --1, B --2..., AA--28, AB--29
etc) must be used..

What will be the best method of converting those letters into numbers?
Jack