Results 1 to 2 of 2

Thread: Error Handling

  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HansV View Post
    Code:
    Sub Macro2()
          ' Suppress error messages temporarily 'What type of error's??
          On Error Resume Next
    ..........
                ' Stop suppressing error messages
          On Error GoTo 0
         End Sub
    With a lot of help from the lounge over recent years, I have learned a lot to do with excel vba, and for that I am hugely grateful. I have never quite got my head around the above, however, so I would appreciate in simplistic terms if anyone could offer me some explanation of what this is useful for, where it should be used, and when etc.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See for example Error Handling In VBA.

Posting Permissions

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