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:
Thanks.
Craig
Bookmarks