====== Error Handling ====== ===== typical example ===== Private Sub someSub() On Error Goto HandleError ' Attempt something here, possibly ' generating an error ExitSub: ' Do cleanup here Exit Sub HandleError: ' Do something about the error Goto ExitSub End Sub ===== ignore errors and keep going ===== Private Sub someSub() On Error Resume Next ' Attempt something here, possibly ' generating an error End Sub ===== alternate HandleError ===== HandleError: Debug.Print "Error: " & _ ' the underscore (_) allows code to continue on the next line Err.Description & ",(" & Err.Number & ")" Resume Next ===== Resume options ===== * **Resume** * this will pick up with the same line causing the error, as if to keep trying * **Resume Next** * resume normal program functionality at the line after the one causing the error * **Resume ** * where is the line number to jump to