Although you can determine the last row and column and get the ALPHA character for the COLUMN and the numeric ROW, how do you use a memory variable with the RANGE property, such as lcColumn that might contain the letter "G" as the Column, for an example.
lcEndColumn = "G"
oExcel.ActiveSheet.Range("A1:G200").NumberFormat="$###,###";($###.###)"