F9 Run Time Error 1004

nancymac623

Board Regular
Joined
Jun 19, 2002
Messages
50
I'm sure this is a no brainer for some, but I'm quite sick of getting this message when I calculate in some spreadsheets by simply clicking F9. I know a little about VBA and play around with it, but since it's a default macro, I'm not sure where to go or what to do to fix it.

Thanks for any help....

More info, the exact message for "Run Time Error 1004" is
"Unable to get the_NewEnum property of the OLEobjects class"
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
If you are getting this error in only some workbooks, then you must have some improper formulae in them.
Can you confirm that you get the error in only certain workbooks?
 

nancymac623

Board Regular
Joined
Jun 19, 2002
Messages
50
Yes, it is only some workbooks, but the number of files with the problem is increasing. That's the reason it's getting so annoying! :x
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Can you email me one of the errant workbooks?
That way I can see if it errors on my PC and also check your formulae.
 

nancymac623

Board Regular
Joined
Jun 19, 2002
Messages
50

ADVERTISEMENT

No, I'm sorry. I tried "sanitizing" it by deleting sheets to allow it out of the company, but then the error message disappeared. That tells me for sure it's something in one of my worksheets causing the probem. I went to every sheet and calculated just that sheet using Shift F9, but I didn't get the message that way either. I only get the message when calcing the entire file.

Is there a systematic way of searching for the worksheet with the problem?
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Delete those sheets one at a time and check using F9 as you delete them.
Once you find the bad sheet, check all formulae closely.
 

nancymac623

Board Regular
Joined
Jun 19, 2002
Messages
50
Thanks, I'll try that tomorrow. :)

Once I find the sheet causing the problem, I'll check the formulas. Could just any formula cause the problem, or it is likely a a particular type?
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Since I can not repeat the error, I don't know if it is a formula or maybe WorkSheet event code causing the error.
Do you have any event procedures taking place?
Right Click the Sheet Tab, click View Code...
If the VBA editor page that opens is blank, you have no worksheet event code.
You can also check for WorkBook event code.
Right Click the Excel Icon to the left of the File Menu, click View Code...
If the VBA editor page that opens is blank, you have no workbook event code.
 

Forum statistics

Threads
1,137,340
Messages
5,680,916
Members
419,945
Latest member
Carrie Sellers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top