S
sharrismail
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
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