Function in VBA or Excel to Convert AA column to ##

[dmwhite]

Does anyone know if there is a function in Excel that converts a "text" column reference (ie. AA or EB) to a proper column number reference that can be used in a cell(row, col) reference.

Thanks.

 

[dan1967]

I think this is what you are trying to accomplish:

Set c = Range("AA1").Column
Set r = Range("AA1").Row
Cells(r, c)

This is, of course, assuming the row you want to use is row 1.



Dan.

 

[dmwhite]

Thanks Dan!

Your answer is obvious and simple.