The 1004 runtime error is caused when you try and copy filtered data into Microsoft Office Excel 2003. The error shows when the data you're trying to copy is either incompatible with your worksheets, or the process which your system is attempting to use to copy the data is unable to function. The 1004 runtime error is normally shown in these messages:
"Runtime error 1004: Paste method of worksheet class failed."
or
"Runtime error 1004: Copy method of Range Class Failed."
Cause of Runtime error 1004
There are two common reasons why this error shows. The first is down to the way in which a Visual Basic "macro" tries to copy a whole row of data into your Excel worksheet - this confuses Excel and leads it to become extremely erroneous and unreliable. The other cause of the error is down to Excel trying to copy 2156 pieces of data into your worksheet - which basically confuses your program and makes it crash.
How can we fix the Runtime error 1004?
The first step to fix the 1004 Runtime Error is to use only the correct data formatting & processing commands inside Excel & Access. The problem you have is that your system likely tried to copy an entire row from one worksheet to another, which will basically overload your computer with information and prevent it from working correctly. To make sure this is not the reason why your PC is restarting, you should look to fix the VB macro you're using to only deal with the specific data you have on your system.
After doing that, it's then recommended that you use a 'registry cleaner' program to fix runtime error 1004 or any other damaged or corrupted settings that will be inside your PC, and could be causing the error to show. Registry cleaners are popular tools which are designed to fix many instances of runtime errors. It's highly recommended you use on of these tools to fix the various problems which will often cause the 1004 error, and any other error on your system, to show.
If you meet this problem, you can fix runtime error 1004 by using the tutorial and tools on our website. You can download a registry cleaner to solve the problem.