View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sharrismail@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Converting column letters to numbers

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