Help ... error-handling routine

[LaShark]

I have a macro the creates over a hundred worksheets but around worksheet 50 and there-after as dialog box is displayed, "Not Enough Memory". If I click ok, the macro con't with no problems and generates all worksheets. I have to click ok button within the dialog box prior to the creation of each worksheet though. Anyone know a error-handling routine to ignore the dialog "Not Enough Memory".

Thnks in advance.

 

[Al Chara]

How about: On Error Resume Next

Hope this helps.
Kind regards, Al.