oExcel.ActiveSheet.Range(lcEndColumn).NumberFormat="$###,###";($###.###)">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="$###,###";($###.###)" >