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