VBA compile Error: unexpected error 35010

Question

I am trying to compile a big project in Excel however the unexpected error is showing up often but not always. One engineer told me that it is related to virtual memory. Can anyone please tell what should I do to eliminate this issue? Thank you!

Answer 1

In my case this happened unexpectedly, the project was not particularly large. Closing the VBA host and reopening allowed the project to compile.

To fix this I'd suggest trying the simplest fixes before heading over to Advanced System Settings...

• close reopen
• repair document / worksheet
• test on other user profile
• test on other PC
• other stuff
• change system settings