Microsoft Excel waa mid ka mid ah xaashiyaha ugu caansan ee loo isticmaalo adduunka oo dhan ujeeddooyin shaqsi iyo ganacsi labadaba. Waa halka hal-joojin ah ee kaydinta, abaabulka, iyo wax-is-beddelka xogta si habaysan. MS Excel wuxuu inta badan ku yimaadaa laba kordhin sida XLS iyo qaabka XLSX . Si kastaba ha noqotee, marka laga reebo caannimadeeda cajiibka ah, khaladaadka runtime waa dhib caadi ah dad badan oo isticmaala Windows - mid ka mid ah kuwa ugu caansan waa Runtime Error 1004 .

Hagahan, waxaanu kaga hadli doonaa khaladkan Runtime^{(Runtime error)} ee caadiga ah 1004 iyo qaar ka mid ah hagaajinta ugu fiican ee lagu xaliyo dadaalla'aan.

Waa maxay Runtime Error 1004 ee Excel ?

Cilada Runtime^(Runtime) 1004 waa koodka khaladka ah ee la xidhiidha Microsoft Visual Basic kaas oo lagu yaqaanay inuu dhibo isticmaalayaasha Microsoft Excel . Ciladaan waxaa soo food saartay nooc kasta oo MS Excel ah sida Excel 2007 , 2010, 2013, 2016, 2019 sidoo kale. Ma jiro nooc ka mid ah Microsoft Excel oo ka badbaadsan khatarta Runtime Error 1004 .

Ciladan waxaa inta badan la kulma isticmaalayaasha marka ay ku shaqeynayaan faylka Excel ama ay isku dayayaan in ay abuuraan Macro dukumeenti Excel ah. Waxay keeni kartaa dhibaato halis ah markaad la shaqaynayso Visual Basic Applications waxayna si buuxda u burburin kartaa barnaamij, ama xitaa nidaamka oo dhan; Mararka qaarkood waxaa laga yaabaa inay qaboojiso nidaamka ka mamnuucaya isticmaalayaasha inay wax ku sameeyaan nidaamkooda.

Noocyada fariinta qaladka

Farriimaha khaladka ah ee inta badan la xidhiidha khaladkan runtime waa sida soo socota:

• VB: qalad run-time '1004': Qaladka codsiga-qeexay ama shayga-qeexay
• Cilada Runtime VBA ee Excel^{(Excel VBA Runtime)} 1004 " Xulashada^(Select) habka fasalka Range waa guuldareystay"
• qalad runtime 1004 habka kala duwan ee shayga _global fashilka muuqaal aasaasiga ah
• Macro Excel "Ciladka Run-waqtiga '1004?
• Qaladka Runtime^(Runtime) 1004 Habka furan ee buugaagta shaqada shay waa guuldarraystay
• Khaladka Run-Time '1004': Habka 'Ranger' of Object' Xaashida shaqada' wuu fashilmay
• " Qaabka^(Method) barnaamijka Furaha ^(Key)U Codsiga waa fashilmay^{(Object Program APPLICATION Failed)} . "

Haddii aad la kulanto mid ka mid ah khaladaadka kor ku xusan, markaa waxaad hagaajin kartaa qaladka adigoo isticmaalaya hagahayaga.

Maxaa sababa?

Khaladka 1004 waa kood guud oo la xidhiidha MS Excel laakiin maaha mid gaar ah sabab sax ah. Sidaa darteed^(Hence) , kiiskan, sababta saxda ah ee uu qaladkani u soo bixi karo way ku kala duwanaan doontaa kiis ilaa xaalad iyo xaalad ilaa xaalad. Laga soo bilaabo arrimaha qaabeynta ilaa dhibaatooyinka software, hoos waxaan ku taxnay dulucda sababaha caadiga ah ee qaladka runtime 1004 ee excel:

• MS Excel Desktop Icon waa la kharribmay
• VBA Excel File waxay isku dhacayaan codsi kale
• Sababo la xiriira codsiga ama shay khalad la cayimay
• Faylka ku-tiirsanaanta maqan awgeed
• Sababo la xiriira Virus, Trojan ama malware
• Sababo la xiriira Furayaasha Diiwaangelinta aan ansax ahayn^{(Invalid Registry Keys)} iyo wixii la mid ah.

Kuwani waxay ahaayeen dhowr ka mid ah sababaha ugu badan ee ka dambeeya helitaanka qaladka runtime 1004 ee MS Excel ; hadda aynu fahamno hagaajinta kala duwan.

Hagaaji qaladka Runtime 1004 ee Excel

Halkan waxaan ku faahfaahiyay xalalka gacanta iyo si toos ah labadaba si loo hagaajiyo Error Runtime 1004^{(Runtime Error 1004)} . Waxaad raaci kartaa mid ka mid ah hababka soo socda si aad u xalliso arrinta.

1. Samee template Excel cusub
2. Samee iskaanka fayraska
3. Wixii VB ah: cilad-waqtiga orodka '1004', wax ka beddel gelinta halyeeyada

Aynu si faahfaahsan u eegno mid kasta oo hababkan ah.

1] Samee template Excel cusub

Xaaladaha qaarkood, hagaajinta arrintan waxay noqon kartaa mid fudud sida gelinta warqad shaqo cusub oo ka timid template halkii laga abuuri lahaa nuqul ka mid ah warqad shaqo oo hadda jirta. Waa kuwan waxaad u baahan tahay inaad sameyso:

1] Ku fur MS Excel nidaamkaaga

2] Taabo ' CTRL + N ' si aad u abuurto xaashi cusub oo Microsoft Excel ah ama si fudud uga dooro ' buug-shaqo maran^{(Blank workbook)} ' shaashadda kowaad.

3] Marka^(Once) la dhammeeyo tirtir dhammaan xaashida buugga shaqada marka laga reebo hal.

4] Hadda, qaabee buugga shaqada, kaas oo laga tagay. Sidoo kale, ogow, buug-shaqeedkan waa la beddeli karaa si uu ugu habboonaado baahidaada gaarka ah.

5] Dhammaadka, u tag ' File > Save As ' si aad u kaydiso xaashida shaqada cusub ee qaabka faylka Excel^{(Excel Template)} (.xltx ama .xlt).

6] Marka aad si guul leh u abuurto template, waxaad gelin kartaa barnaamij ahaan adigoo isticmaalaya xariiqda koodka:

Sheets.Add Type:=path\filename

Fadlan ogow -^{(Please note – )} Ha iloobin inaad ku beddesho faylka cusub magaca dhabta ah ee dukumeentiga.

2] Samee iskaanka fayraska

Aad bay muhiim u tahay in laga baadho nidaamka kombiyuutarkaaga malware-ka iyo fayrasyada maxaa yeelay kuwani waxay kharribi karaan faylasha iyo dukumentiyada muhiimka ah waxayna muujinayaan qaladka runtime 1004 ee MS Excel . Mararka qaarkood isticmaalka barnaamij ka hortag wanaagsan ayaa wax badan ka caawiya.

la xiriira^(Related) : Run-time qalad 1004, Ma wadi karo Macro ee Excel^{(Run-time error 1004, Cannot run the Macro in Excel)} .

3] Wixii VB ah: cilad-waqtiga orodka '1004', wax ka beddel gelinta halyeeyada

Haddii aad la kulanto Runtime Error 1004 markaad wado Microsoft Visual Basic for Applications ( VBA ) macro, markaa waxaad isticmaali kartaa habkan si aad u shaqeyso.

Guud ahaan, waxa aad helaysaa qaladkan marka aad isku daydo in aad maamusho VBA macro kaas oo isticmaala habka LegendEntries si uu isbeddel ugu sameeyo halyeyga shaxanka Microsoft Excel . Waqtigaas, waxa aad heli kartaa fariinta khaladka ah ee soo socota:

Cilad-wakhti-u-dhimista '1004': Qaladka codsiga ama shayga qeexan

Ciladani waxay dhacdaa marka jaantuska Excel uu ka kooban yahay gelinta halyeeyo ka badan inta ay jirto meel bannaan oo lagu soo bandhigo halyeyga jaantuska Excel . Marka habdhaqankani dhaco, Microsoft Excel waxa laga yaabaa inay gooyso gelinta halyeeyada.

Si aad ugu shaqeyso habdhaqankan, samee makro kaas oo yareynaya cabbirka font ee qoraalka jaantuska Excel ka hor inta uusan VBA -gaagu isbeddel ku samayn halyeeyga jaantuska ka dibna dib u soo celi cabbirka font ee halyeeyga jaantuska si ay ula mid noqoto tusaalaha soo socda .

Sub ResizeLegendEntries()
With Worksheets("Sheet1").ChartObjects(1).Activate
      ' Store the current font size
      fntSZ = ActiveChart.Legend.Font.Size
'Temporarily change the font size.
      ActiveChart.Legend.Font.Size = 2
'Place your LegendEntries macro code here to make
         'the changes that you want to the chart legend.
' Restore the font size.
      ActiveChart.Legend.Font.Size = fntSZ
   End With
End Sub

Waxaan rajeyneynaa in maqaalkani uu kaa caawiyo inaad hagaajiso qaladka runtime 1004 ee Microsoft Excel . Hagahan waxa uu ku siinayaa buug-gacmeed iyo sidoo kale xal toos ah si aad uga takhalusto khaladkan; waxaad isticmaali kartaa xal kasta oo ku salaysan baahidaada.

Akhri soo socda^{(Read next)} : Furayaasha fallaadhaha oo aan ka shaqayn Microsoft Excel.

How do I fix Runtime Error 1004 in Microsoft Excel?

Microsoft Excel is one of the most popular spreadsheets used across the globe for both individual and business purposes. It is the one-stop destination for storing, organizing, and manipulating data in an organized way. MS Excel comes mainly in two extensions i.e. XLS and XLSX format. However, apart from its incredible popularity, runtime errors are a common nuisance for a great many Windows users – and one of the most common ones is the Runtime Error 1004.

In this guide, we are going to discuss this common Runtime error 1004 and some of the best fixes to resolve it effortlessly.

What is Runtime Error 1004 in Excel?

Runtime error 1004 is an error code relating to Microsoft Visual Basic that has been known to disturb Microsoft Excel users. This error is faced by any versions of MS Excel such as Excel 2007, 2010, 2013, 2016, 2019 as well. No version of Microsoft Excel is safe from the menace of Runtime Error 1004.

This error is mainly encountered by users while they are working on an excel file or trying to generate a Macro in the excel document. It can cause serious trouble while working with Visual Basic Applications and can completely crash a program, or even the entire system; sometimes it may freeze the system prohibiting the users to do anything on their system.

Types of error message

The error messages that are most associated with this runtime error are as follows:

• VB: run-time error ‘1004’: Application-defined or object-defined error
• Excel VBA Runtime error 1004 “Select method of Range class failed”
• runtime error 1004 method range of object _global failed visual basic
• Excel macro “Run-time error ‘1004?
• Runtime error 1004 method open of object workbooks failed
• Run-Time error ‘1004’: Method ‘Ranger’ of Object’ Worksheet’ Failed
• “Method in Key up Object Program APPLICATION Failed.”

If you encounter any of these above errors, then you can fix the error using our guide.

What are the causes?

The Error 1004 is a general code related to MS Excel but is not specific to one exact cause. Hence, in this case, the exact reason why this error might pop up will vary from case to case and circumstance to circumstance. From configuration issues to software problems, below we listed a synopsis of common reasons for runtime error 1004 in excel:

• MS Excel Desktop Icon might be corrupted
• VBA Excel File is clashing with other application
• Due to application or object specified error
• Due to missing dependent file
• Due to Virus, Trojan or malware
• Due to Invalid Registry Keys and so on.

These were a few of the most common reasons behind getting the runtime error 1004 in MS Excel; now let us understand the different fixes.

Fix Runtime Error 1004 in Excel

Here we have detailed both manual and automatic solutions to fix the Runtime Error 1004. You can follow any one of the next methods to resolve the issue.

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

Let’s look at each of these methods in detail.

1] Create a new Excel template

In some cases, fixing this issue can be as simple as inserting a new worksheet from a template instead of creating a copy of an existing worksheet. Here is what you need to do:

1] Open MS Excel on your system

2] Press ‘CTRL + N’ to create a new Microsoft Excel worksheet or simply select a ‘Blank workbook’ from the first screen.

3] Once done delete all the sheets on the workbook except one.

4] Now, format the workbook, which has been left. Also, note, this workbook can be modified to suit your individual need.

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

6] Once you have successfully created the template, you can insert it programmatically by using the following line of code:

Sheets.Add Type:=path\filename

Please note – Do not forget to replace the new filename with the actual name of the document.

2] Run a Virus Scan

It is very important to scan your computer system for malware and viruses as these can corrupt files and important documents and show the runtime error 1004 in MS Excel. Sometimes using a good antivirus program helps a lot.

Related: Run-time error 1004, Cannot run the Macro in Excel.

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

If you come across a Runtime Error 1004 when running a Microsoft Visual Basic for Applications (VBA) macro, then you can use this method to work-around.

Generally, you get this error when you try to run a VBA macro that uses the LegendEntries method to make changes to legend entries in a Microsoft Excel chart. That time, you may receive the following error message:

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

This error occurs when the Excel chart contains more legend entries than there is space available to display the legend entries on the Excel chart. When this behavior occurs, Microsoft Excel may truncate the legend entries.

To work around this behavior, create a macro that reduces the font size of the Excel chart legend text before your VBA macro makes changes to the chart legend and then restore the font size of the chart legend so that it is similar to the following macro example.

Sub ResizeLegendEntries()
With Worksheets("Sheet1").ChartObjects(1).Activate
      ' Store the current font size
      fntSZ = ActiveChart.Legend.Font.Size
'Temporarily change the font size.
      ActiveChart.Legend.Font.Size = 2
'Place your LegendEntries macro code here to make
         'the changes that you want to the chart legend.
' Restore the font size.
      ActiveChart.Legend.Font.Size = fntSZ
   End With
End Sub

We hope this article helps you fix the runtime error 1004 in Microsoft Excel. This guide gives you manual as well as automatic solution to get rid of this error; you can make use of any solution based on your need.

Read next: Arrows keys not working in Microsoft Excel.

Related posts

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida foormulada loogu qariyo xaashiyaha Microsoft Excel

• Hagaaji Soo Celinta Xogta. Sug dhowr ilbiriqsi oo isku day inaad mar kale gooyso ama nuqul ka sameyso qaladka Excel

• Hagaaji BitLocker Drive Encryption lama isticmaali karo, Khaladka 0x8031004A

• Waxaad u baahan doontaa internetka qaladkan 0x80070cf Dukaanka Windows

• Sida loogu isticmaalo shaqada TRUNC ee Microsoft Excel oo wata Tusaalayaal

• Sida loogu daabaco baqshadda gudaha Microsoft Excel

• Xallinta arrimaha bixinta xisaabaadka Microsoft iyo dhibaatooyinka

• Hagaaji khaladaadka sawirada Microsoft Edge ee Windows 10

• Khaladaadka daabacaha 0x00000709 marka aad isku daydo inaad ku xidho ama dejiso Default

• Xeerarka khaladka gadhka badda ee tuugada & waxa ay ula jeedaan

• Sida loo Quful Unugyada Microsoft Excel

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel