Steps To Resolve Runtime Error 1004
Runtime Error 1004 may appear on your computer when you try to copy and paste filtered data into a Microsoft Excel 2003 workbook. The error message you receive may look something like either one of the following:
“Runtime error 1004: Paste method of worksheet class failed.”
or you may also receive this error message:
“Runtime error 1004: Copy method of Range Class Failed.”
However you may still receive the error message even though the data is pasted into the workbook.
What Causes Runtime Error 1004
Each runtime error has it’s own set of individual causes and symptoms, however the runtime error 1004 may occur if either of the following are true:
- The Microsoft Visual Basic for Applications macro copies and pastes one whole row in an Excel 2003 workbook.
- The Microsoft Visual Basic for Applications macro copies and pastes a range of 2516 rows or more rows in an Excel 2003 workbook.
One of the ways you can work around this problem is to make sure that you are only using specific Microsoft Excel Row Data, the next paragraph will show you how to do this. You may also want to clean out the registry of your computer to ensure Excel is working correctly.
How To Fix Runtime Error 1004
Step 1 – Make Sure You Are Only Using Specific Microsoft Excel Row Data
Excel often shows errors because it simply cannot compute the data you have provided for it. You must ensure you are using the correct inputted data and the right cells. To work around the problem, if your Visual Basic Application macro copies and pastes a single whole row, change the Visual Basic Application code to copy only the section of the row that contains the data. For example, use the Visual Basic Application macro code that is similar to the following code you will see below:
“Range(Range(“A” & ActiveCell.Row), Range(“IV” & ActiveCell.Row).End(xlToLeft)).Select”
That solves one issue, but there is one more. To work around the problem if you Visual Basic Application macro copies and pastes a range of 2516 rows or more, then change your Visual Basic Application macro code to loop to copy and to paste smaller ranges of data until that range that you desire is copied and pasted.
Step 2 – Use A Registry Cleaner
You should also clean out the ‘registry’ of your PC to make sure the Excel application is working okay. The “registry” is a database which stores vital information, settings and options for your system, and is where Windows & all your software programs keep valuable data that your PC requires to run. Unfortunately, it’s also one of the biggest causes of errors because it’s continually being saved in the wrong way, making many of its settings corrupt and unreadable. In order to fix this problem, it’s advisable you use a registry cleaner program to fix any errors that could be causing problems inside this database. You can download these tools from the Internet, and you can also see our recommended cleaner below: