>>oexcel.Range(oexcel.activesheet.cells(7,3)).Select >>>>would work, but it doesn't.
>with oExcel.ActiveSheet > .Range(.Cells(7,3), .Cells(7,3)).Select() >endwith >>
>with oExcel.ActiveSheet > oExcel.ActiveSheet.Range(oExcel.ActiveSheet.Cells(7,3),; > oExcel.ActiveSheet.Cells(7,3)).Select() >endwith >>
>loSheet = loExcel.ActiveSheet >... >loSheet.Cells(...).Value = ... >loSheet.Range(loSheet.Cells(7,3), loSheet.Cells(7,3)).Select() >See Fred's post regarding .Address which eliminates the need for a second cell reference. This is more consistent with my mental paradigm. Regarding the reference to oSheet, of course that's the way to do it. It's just that your first example wasn't clear as to the path that had been established.