By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 585 - Resume Next or Label - Error Handling

The resume statement is used for Error handling

Resume Next will resume the code after the statement that caused the error

Resume label will do a Goto the label you specify

You need the following for them to occur



Sub Test_Resume_Next()

On Error Goto the_label



Err.Raise 9



Msgbox "After Error"



Exit sub





the_label:

   Resume Next



End Sub