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="$###,###";($###.###)"
>