[breadcrumb_simple]

Run-time error 1004 is a Microsoft Visual Basic error code that affects users of Microsoft Excel. The error is known to be the most prevalent in Excel 2003 and Excel 2007, although no version of Microsoft’s popular computer spreadsheet application is immune to the threat that is the most common error. In most cases, the users affected by this problem see one of two different variations of run-time error 1004.

Common Excel Runtime Errors and Problems

Here are some of the most common problems reported by users over time:

Runtime Error 1004: The Ranger of Object Worksheet method failed.

• Error executing the Excel 1004 macro.
• Runtime error 1004: Application error or object-defined error.
• Runtime Error 100: Range of the method of the _global object that failed with Visual Basic.
• Excel 1004 VBA Runtime Error “The method of selecting the Range class failed”.
• Runtime error The VBAProject method 1004 of the _workbook object failed.
• Save as VBA execution error 1004: application-defined or object-defined error.

Follow the methods to solve Excel Error 1004

Step 1: Make sure to use only specific Microsoft Excel line data

Excel often displays errors because it simply can not calculate the data you have provided. You need to make sure that you are using the right data and the right cells. To work around the problem, if your Visual Basic application macro copies and pastes an entire line, modify the Visual Basic application code to copy only the section of the line containing the data.

Step 2: Follow the steps

1. Launch Excel.
2. Create a new workbook, and delete every single worksheet the workbook contains save for one.
3. Format the workbook.
4. Add any text, data and/or charts you wish to have in the template by default to the only worksheet the workbook now contains.
5. If you are using Excel 2003 or earlier, click on File > Save As. If you are using Excel 2007 or later, on the other hand, click on the Microsoft Office button and then click on Save As.
6. In the File name:field, type in whatever you want the template to be called.
7. Open the dropdown menu next to the Save as type:field and click on Excel Template (.xlt) if you are using Excel 2003 or earlier, or Excel Template (.xltx) if you are using Excel 2007 or later to select it.
8. Click on Save.
9. Once you have successfully created the template, you can insert it programmatically by using the following line of code:
   Add Type:=path\filename