Consulting

Results 1 to 2 of 2

Thread: On error resume next

  1. #1

    On error resume next

    Hi,

    I do not like to use the 'on error resume next' statement, since it ignores errors. However, for one single piece of code I have to use it. Is it possible to reverse/cancel the statement by using a line of code when you don't need it anymore? Also, how long will Excel continue to take into account the statement?

    thx

  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    You can use either On Error Goto 0 to cancel all error handling or On Error Goto label to initialise your own error handler. On Error Resume Next will carry on until cancelled or until the routine ends.

Posting Permissions

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