Help ... error-handling routine

LaShark · Mar 18th, 2002, 10:50 AM

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 · Mar 18th, 2002, 11:00 AM

How about: On Error Resume Next

Hope this helps.
Kind regards, Al.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 10:50 AM	#1
LaShark New Member Join Date: Mar 2002 Posts: 9	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.

Mar 18th, 2002, 11:00 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	How about: On Error Resume Next Hope this helps. Kind regards, Al.