On Error Goto 0 not resetting error trapping On Error Goto 0 not resetting error trapping vba vba

On Error Goto 0 not resetting error trapping


You need to use On Error GoTo -1 or Err.Clear to reset error trapping.

Check this answer I posted a few months ago for a more detailed explanation.