You can fix VBA Runtime Error 1004 in Excel Macro, like document not found, reference isn't valid, Paste method of worksheet class failed, etc, by following this post.

To do that, hit Win + S, type “ Add or remove programs ”, and click Open. Now, search out the application that’s giving you the Runtime error, select, and click Uninstall.