About

Although you could use Visual Basic string functions to alter A1-style references, it's much easier (and much better programming practice) to use the Excel - Cell(1, 1) notation.

Articles Related

Column Number

ActiveCell.Column

From Letter to Number

colNumber = Range(colLetters & "1").Column