>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="$###,###";($###.###)"
>
Why bother with the letters and numbers? You can address everything in Excel using row and column numbers.
Tamar