Run Time error when macro references copy range on a separate worksheet

Hopefully, this is a simple problem with the code on Sheet1 that is run on deactivation. I have moved the range that is being copied (Copy_Range) to a new sheet (Copy) so that it won't be deleted accidentally.

Now when you move off Sheet1, the macro runs and "Run-time error ‘1004’:
Method ‘Range of Object’_Worksheet’failed" is returned. IF I click "OK", the pivottable is still properly populated, however I don't want the run-time error.

Hopefully this is simply a syntax error in the sheet1 code:

Please Login or Register  to view this content.

Thanks.

Craig

Thanks very much, TMS. I tried to qualify the worksheets, but I am not very experienced in code writing, so the problem is likely with the syntax. I tried the code below, but something isn't working. Please let me know if you see an obvious error.

Thanks again.

CDEG

Please Login or Register  to view this content.

Thanks again. This worked and that is all I needed. Many thanks.