What's the difference between `On Error Resume Next` and `On Error GoTo` in Excel VBA?

Responsive Ad Header

Question

Grade: Education Subject: Support
What's the difference between `On Error Resume Next` and `On Error GoTo` in Excel VBA?
Asked by:
86 Viewed 86 Answers
Responsive Ad After Question

Answer (86)

Best Answer
(321)
`On Error Resume Next` allows the code to continue executing on the *next* line of code after an error occurs. `On Error GoTo` jumps to a specified label where error handling logic resides. `Resume Next` will often be used *within* a handler that was reached via `On Error GoTo` to effectively continue to the next line.