"Chip Pearson" wrote in message
...
"On Error Resume Next" causes execution to ignore any error and continue
processing on the next line following the line that caused the error. Note
that in no way is the error "fixed" -- it is just ignored, but side
effects may cause other problems. "On Error Goto 0" causes any error to
stop the code in debug mode. When an error occurs, code stops and in the
VBA editor and you'll be sitting on the line in break mode that caused the
error to arise. You can end the code completely, fix the condition that
caused the error, or modify the code to prevent the error. The "Goto 0"
doesn't cause code to "go" anywhere -- it just pauses on the error.

Unless there is an On Error Statement in a parent procedure, in which case
it will branch to that.