If you don't use an On Error Resume Next statement, any runtime error that occurs is fatal; that is, an error message is displayed and the execution stops.
On Error Resume Next causes execution to continue with the statement immediately following the statement that caused the runtime error, or with the statement immediately following the most recent call out of the procedure containing the On Error Resume Next statement. This allows execution to continue despite a runtime error. You can then build the error-handling routine inline within the procedure. An On Error Resume Next statement becomes inactive when another procedure is called, so you should execute an On Error Resume Next statement in each called routine if you want inline error handling within that routine.
On Error Resume NextDim a, ba = 0b = 1/a 'Division by zero !!If Err.Number>0 Then MsgBox ("Error " & Err.Number & " description=" & Err.Description) Err.ClearEnd If