Solved fix Runtime Error 1004 in Microsoft Excel

Microsoft Excel is without doubt one of the hottest spreadsheets used throughout the globe for each particular person and enterprise functions. It’s the one-stop vacation spot for storing, organizing, and manipulating knowledge in an organized approach. MS Excel comes primarily in two extensions i.e. XLS and XLSX format. Nonetheless, other than its unbelievable recognition, runtime errors are a standard nuisance for an incredible many Home windows customers – and probably the most frequent ones is the Runtime Error 1004.

On this information, we’re going to focus on this frequent Runtime Error 1004 and a few of the finest fixes to resolve it effortlessly.

What’s Runtime Error 1004 in Excel?

Runtime error 1004 is an error code regarding Microsoft Visible Primary that has been recognized to disturb Microsoft Excel customers. This error is confronted by any variations of MS Excel similar to Excel 2007, 2010, 2013, 2016, 2019 as nicely. No model of Microsoft Excel is secure from the menace of Runtime Error 1004.

This error is especially encountered by customers whereas they’re engaged on an excel file or attempting to generate a Macro within the excel doc. It could actually trigger severe hassle whereas working with Visible Primary Functions and may fully crash a program, and even your complete system; sometimes it may freeze the system prohibiting the customers to do something on their system.

Kinds of error message

The error messages which might be most related to this runtime error are as follows:

  • VB: run-time error ‘1004’: Utility-defined or object-defined error
  • Excel VBA Runtime error 1004 “Choose technique of Vary class failed”
  • runtime error 1004 technique vary of object _global failed visible fundamental
  • Excel macro “Run-time error ‘1004?
  • Runtime error 1004 technique open of object workbooks failed
  • Run-Time error ‘1004’: Methodology ‘Ranger’ of Object’ Worksheet’ Failed
  • “Methodology in Key up Object Program APPLICATION Failed.”

When you encounter any of those above errors, then you may repair the error utilizing our information.

What are the causes?

The Error 1004 is a normal code associated to MS Excel however will not be particular to 1 precise trigger. Therefore, on this case, the precise purpose why this error would possibly pop up will fluctuate from case to case and circumstance to circumstance. From configuration points to software program issues, under we listed a synopsis of frequent causes for runtime error 1004 in excel:

  • MS Excel Desktop Icon is perhaps corrupted
  • VBA Excel File is clashing with different utility
  • As a consequence of utility or object specified error
  • As a consequence of lacking dependent file
  • As a consequence of Virus, Trojan or malware
  • As a consequence of Invalid Registry Keys and so forth.

These had been just a few of the commonest causes behind getting the runtime error 1004 in MS Excel; now allow us to perceive the completely different fixes.

Repair Runtime Error 1004 in Excel

Right here we have now detailed each guide and automated options to repair the Runtime Error 1004. You may comply with any one of many subsequent strategies to resolve the problem.

  1. Create a brand new Excel template
  2. Run a Virus Scan
  3. For VB: run-time error ‘1004’, resize legend entries

Let’s have a look at every of those strategies intimately.

1] Create a brand new Excel template

In some circumstances, fixing this subject will be so simple as inserting a brand new worksheet from a template as a substitute of making a duplicate of an current worksheet. Here’s what you must do:

1] Open MS Excel in your system

2] Press ‘CTRL + N’ to create a brand new Microsoft Excel worksheet or just choose a ‘Clean workbook’ from the primary display.

3] As soon as carried out delete all of the sheets on the workbook besides one.

4] Now, format the workbook, which has been left. Additionally, notice, this workbook will be modified to fit your particular person want.

5] Ultimately, go to ‘File > Save As’ to save lots of the brand new worksheet with the Excel Template (.xltx or .xlt) file format.

6] After getting efficiently created the template, you may insert it programmatically by utilizing the next line of code:

Sheets.Add Kind:=path\filename

Please notice – Don’t forget to exchange the brand new filename with the precise identify of the doc.

2] Run a Virus Scan

It is vitally necessary to scan your pc system for malware and viruses as these can corrupt recordsdata and necessary paperwork and present the runtime error 1004 in MS Excel. Generally utilizing a very good antivirus program helps loads.

3] For VB: run-time error ‘1004’, resize legend entries

When you come throughout a Runtime Error 1004 when working a Microsoft Visible Primary for Functions (VBA) macro, then you should use this technique to work-around.

Usually, you get this error whenever you attempt to run a VBA macro that makes use of the LegendEntries technique to make modifications to legend entries in a Microsoft Excel chart. That point, it’s possible you’ll obtain the next error message:

Run-time error ‘1004’: Utility or object-defined error

This error happens when the Excel chart incorporates extra legend entries than there may be house out there to show the legend entries on the Excel chart. When this conduct happens, Microsoft Excel might truncate the legend entries.

To work round this conduct, create a macro that reduces the font measurement of the Excel chart legend textual content earlier than your VBA macro makes modifications to the chart legend after which restore the font measurement of the chart legend in order that it’s much like the next macro instance.

Sub ResizeLegendEntries()
With Worksheets("Sheet1").ChartObjects(1).Activate
      ' Retailer the present font measurement
      fntSZ = ActiveChart.Legend.Font.Dimension
'Briefly change the font measurement.
      ActiveChart.Legend.Font.Dimension = 2
'Place your LegendEntries macro code right here to make
         'the modifications that you simply need to the chart legend.
' Restore the font measurement.
      ActiveChart.Legend.Font.Dimension = fntSZ
   Finish With
Finish Sub

We hope this text helps you repair the runtime error 1004 in Microsoft Excel. This information offers you guide in addition to automated answer to do away with this error; you can also make use of any answer primarily based in your want.