SUE' EXCEL WORLD: Excel and Excel VBA - Convert column letter to number

For those who are regularly programming VBA code, you can use the Immediate window located at the bottom of the VBA Editor by typing this:?ActiveCell.Column Once you type this string, press Enter. The Immediate window will return the corresponding number

exceltipsandkeys.blogspot.com