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):
and also similar like
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
Bookmarks