Hi,

in a code I faced with a lot of copy paste operation between different sheets. I see that this kind of statement doesn't work when the referred sheet is not selected (j and k are integer variables and >0):

Sheets(sh.Name).Range(Cells(j + 1, 1), Cells(j + k, 7)).Copy
and also similar like

Worksheets(sh.Name).Range(Cells(j + 1, 1), Cells(j + k, 7)).Copy
sh.Range(Cells(j + 1, 1), Cells(j + k, 7)).Copy
do not work.

The only way I see i to not use the "cells(...)" function inside "range(...)", but I find it a very simple way to refer to cells with variables like j and k in the example.

I wonder also if there's a way avoid this problem without the necessity to select the sheet.

Thans a lot
Regards
Diego