VBA: overcome error and complete the task

[sunilbsrv2k]

Hi,

I have written a code in VBA to complete a report

However, the report , not sure though, gives an error something like --- "Excel ran out of resources.....".

This interrupting the macro to run completely and hence have to manually click on 'OK' everytime this occurs.

Is there away to override this error and allow the macro to run completely.

Thanks

 

[Caleeco]

Generally this is caused by a memory issue.

It could be avoided by optimising the code, the data or purchasing more RAM . Are you able to share the code so we can assess what needs doing?

Caleeco