| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.vb.general.discussion
|
|||
|
|||
Excel columns: Converting numbers to letters and vice versa
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding columns based upon a value (or vice versa) | Excel Programming | |||
| I want columns of worksheet to become rows and vice-versa. | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| Can I rotate excel sheets so columns are rows & vice-versa (i.e.. | Excel Discussion (Misc queries) | |||
Threaded Mode
