Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Help ... error-handling routine

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How about: On Error Resume Next

    Hope this helps.
    Kind regards, Al.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •