Excel Vba Copy Worksheet Runtime Error 1004. In the second case, we don't have the "myRange". When I open the file it runs a code to create a new toolbar in Excel, when I press a button on the toolbar, the code I have described above runs.
When I open the file it runs a code to create a new toolbar in Excel, when I press a button on the toolbar, the code I have described above runs.
This is an error when we select a range in another worksheet without activating the worksheet we are referring to.
The code was running perfect when I was running it from my desktop and saving the files on my local C The WbNew. Some of the solutions to this error include saving the Excel file using the correct file extension. This GitHub forum is specifically for suggested changes and additions to the VBA documentation.







