How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask LeGin Your Own Question
LeGin
LeGin, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 755
Experience:  BSc (Computer Science)
15216141
Type Your Microsoft Office Question Here...
LeGin is online now
A new question is answered every 9 seconds

I just upgraded to excel 2010 from excel 2003. I have installed

Customer Question

I just upgraded to excel 2010 from excel 2003. I have installed service pack 1 for office 2010. Since the upgrade, there are 2 errors that occur after repeatedly opening and closing a userform:
&h8000ffff error code (-2147418113). Catastrophic Failure
&H80004005 (-2147467259). Unspecified Error

No isolated line of code will cause this that I can tell. This is especially true because it will work a few times before the error occurs. I can't seem to find a blog on how to fix this. Please help.
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  LeGin replied 5 years ago.

space2009 :

Hello

space2009 :

when does this error occur, while running a macro?

space2009 :

r u there

space2009 :

try this goto developer tab on the ribbon menu click visual basic. Click on the Tools menu, select Options...

Click on the Editor tab and select "Require Variable Declaration".

space2009 :

close VB Editor & Excel.

space2009 :

restart Excel and let me know if you get the same error again.

space2009 :

Let me know if you have any other questions in this regards.

space2009 :

If you found the answer helpful kinldy click ACCEPT/ Thanks

space2009 :

Let me know if you have any Question, if not please click ACCEPT. Thanks

JACUSTOMER-e2z1q4o6- :

I tried this and unfortunately, it did not work. Thanks.

space2009 :

Are you executing a macro file when this error pops up?

space2009 :

r u there

space2009 :

I see you as standing by.

Related Microsoft Office Questions