CODEWITHSUNDEEP
vbaexcel
Fabio Rebelo
Fabio Rebelo

Reputation: 109

VBA Ignore Excel cannot complete this task with available resources

I'm writing a VBA code that will run everything after I leave the office. The macro works fine, the problems is that sometimes (more often than I'd like) I get the message:

Excel cannot complete this task with the available resources. Choose less data or close other applications. Excel cannot complete this task with the available resources. Choose less data or close other applications. Continue without Undo?

I just click OK and the code runs fine, but I have do click the OK manually, I've already tried the Application.DisplayAlerts = False but this doesn't work. Does anyone know if I can't make excel "overpass" this problem?

Thank you in advanced

Upvotes: 0

Views: 5289

Answers (1)

Instant Breakfast
Instant Breakfast

Reputation: 1445

I believe "Continue without Undo" means Excel is temporarily clearing the RAM it uses to track undo levels and then (it seems) your macro has the resources it needs to complete the process.

Take a look at what your macro is doing to use so much RAM: Is there a way to modify it so that less RAM is required? There are several options for this listed here:

How to clear memory to prevent "out of memory error" in excel vba?

Second option to fix this might be adding RAM to your machine, but it will not fix the cause of the error.

Third, if you want to risk a registry edit and reduced or eliminated undo levels in Excel, you might be able to prevent this error by reducing the number of undo levels (http://support.microsoft.com/kb/211922).

Upvotes: 0

Related Questions