Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For those seeking a way to convert Excel column letters to numbers, I
offer the below poperty because it may be the answer you're looking for and does not involve reproducing functionality which may already exists: It's called the "Range" property (referred to as poperty although its behavior brings the notion of object to mind). It receives cell references as inputs vs. row/column index numbers and thus you can access info regarding a cell or range of cells without first converting column letters to numbers, such as: Range("A1").Text See the "Referring to Cells and Ranges by Using A1 Notation" topic under Excel's Microsoft Visual Basic Help for more information regarding it. S. R. Harris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting text to cell reference and column letters to numbers -please help | Excel Worksheet Functions | |||
Converting letters to numbers | Excel Worksheet Functions | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
converting letters to numbers | Excel Discussion (Misc queries) | |||
Converting numbers to column letters | Excel Programming |