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.

If you see Microsoft Visual Basic, Run-time error, Class not registered in Office Excel, follow these solutions that have helped many fix the issue.

Program developers often release updates to fix bugs and improve performance. If you’re encountering a runtime error, it might be due to a known issue already addressed in a newer program version.