Runtime error 1004 is frequently followed by some text such as “Copy method of worksheet class failed,” “Programmatic access to Visual Basic Project is not trusted,” or “Application-defined or object-defined error.” If course, plenty of variations to this particular message exist. Runtime error 1004 is occasionally generated while working with Microsoft Excel or Visual Basic.
Free Download Run-time error 1004 Repair Tool
The correct way to Fix Runtime Error 1004: Use Reimage
Recommended if you have:
- an English-language version of Windows XP, Windows Vista or Windows 7
- a French, Hebrew or Spanish-language version of Windows Xp
Reimage is designed to remove a wide range of computer problems, such as Run-time error 1004 and blue screen errors, freezes, system file and registry damage, viruses, trojans and other troubles. This is the only tool that not only detects and removes viruses but also undo the damage done to the system by a virus. Moreover, Reimage is widely used by PC technicians to fix Windows errors.
1) Install the program and launch.
2) Let the program scan the computer for errors and let it repair the error.
Reimage is the only program of its type. It’s not simply a registry fix, PC optimizer, an anti-virus scanner or a fix for damaged files - it UNDO damages to your Windows OS, totally eliminating the need for reinstalling (see the table below). In simple terms, Reimage repair is the same as getting a new, healthy installation of Windows and keeping all you programs, settings, user profiles, data, updates, etc, as they were, which has never been possible before.
Free Download Reimage
The way to Fix Runtime Error 1004: Visual Basic
Just follow one of these sets of directions to resolve a runtime error that happens while using Visual Basic within Excel.
Set 1:
1) Open your Microsoft Excel application.
2) Select Tools from the top of the menu.
3) Select Macros.
4) Select Security.
5) Select “Choose trusted publisher” from the Security dialog box.
6) Select “Trust Access to Visual Basic Project.”
7) Select Ok.
Set 2: Problems copying and pasting data
1) Change the VBA Macro code so that it only copies and pastes a single row, specifically the portion of the row that contains the data.
OR
2) Change the VBA Macro code so that it loops to copy and so that it pastes smaller ranges of data.
How to Fix Runtime Error 1004: Microsoft Excel
If you receive the runtime 1004 error along with this text: “Method on Key Up Object_Application Failed,” use these directions:
Right click on Start.
Select Explorer.
Open C:\Program Files\MS Office\XLSTART directory.
Delete this file: GWXL97.XLA.
Close Explorer.
Open your Microsoft Excel application.
How to Fix Runtime Error 1004: Copying and Pasting in Microsoft Excel
When runtime error 1004 occurs while using Excel, it is usually generated by copying the worksheet more than once without saving your work and closing the workbook in between. The easiest strategy here is to prevent runtime error 1004 from occurring simply by saving and closing the worksheet periodically. This strategy also varies according to the size of your worksheet, so you would possibly need to close the application more regularly in some instances.
It is also possible to use the following directions to work around this problem when using Microsoft Excel.
Microsoft Excel 2003 or Earlier Version
1) Create a new workbook in Excel.
2) Delete all but one of the worksheets.
3) Format the workbook.
4) Add any data, charts, or text that you wish to have within the template by default.
5) Navigate to File and select Save as.
6) Select Template (*.xltx) in the Save as Type list and click on Save.
7) Use the code listed here if you wish to insert the template programmatically: Sheets.Add Type:=path\filename where path\filename refers to the full path and the full file name for your template.
Microsoft Excel 2007
1) Create a new workbook in Excel.
2) Delete all but one of the worksheets.
3) Format the workbook.
4) Add any data, charts, or text that you wish to have within the template by default.
5) Select the “Microsoft Office Button” and select Save As.
6) Type the name that you wish to use to save the file in the File Name box.
7) Select Template (*.xltx) in the Save as Type list and click on Save.
8) Use this code if you wish to insert the template programmatically: Sheets.Add Type:=path\filename where path\filename refers to the full path and the full file name for your template.
Free Download Reimage
