Resume Statement

The Resume statement can be used to resume execution after a run-time error occurs.
You can only use this statement inside an error handling routine.
Every time this statement is executed the Err Object is automatically reset.

Resume

ErrorHandler: 
   Resume 
End Sub 

This will move the execution back to the statement that caused the error.
If the error has not been resolved, the same error will be raised again which will create an infinite loop.

Resume Next

ErrorHandler: 
   Resume Next 
End Sub 

This will move the execution to the line after the statement that caused the error.
If the error occurred in the same procedure as the error handler, execution resumes with the statement immediately following the statement that caused the error.
If the error occurred in a called procedure, execution resumes with the statement immediately following the statement that last called out of the procedure containing the error-handling routine (or the On Error Resume Next statement).

Resume LineLabel

LineLabel: 

ErrorHandler: 
   Resume LineLabel 
End Sub 

This will move execution to the corresponding line label.
The line argument is a line label or line number and must be in the same procedure as the error handler.

Nested Subroutines

If the error occurred in a called procedure, execution resumes at the statement that last called out of the procedure containing the error-handling routine.

Sub MySubroutine() 
    On Error Resume Next 
    Call MySub2                  'the run-time error is ignored  
End Sub 

Sub MySub2() 
    Charts("Chart 1").Activate   'this generates a runtime error  
End Sub 

Resume without error

If it is used outside of an error handling routine a runtime error 20 "Resume without error" error will occur.
SS