on error

  • Thread starter Thread starter joemeshuggah
  • Start date Start date
J

joemeshuggah

does on error in vba only refer to the line of code right below it, or does
it reference the entire macro?

i was under the impression it only looked at the line below, but seems to be
effective for all.

e.g.


On Error GoTo SkipRemainder
Sheets.Add.Name = "Daily Report"

if, for example, the tab Daily Report already existed, the on error would
skip to the end of all code. but if another line of code after
Sheets.Add.Name = "Daily Report" generates an error, it would also skip to
the end? is there a way to get on error coding to only look at the line of
code directly below it?
 
On Error applies until you tell it to stop

Use :
On Error Goto 0 to reset to the default error handling
 
In addition to advice from Paul...

You could use the statements:

On Error Resume Next
Sheets.Add.Name = "Daily Report"
If Err.Number <> 0 then goto SkipRemainder
On Error Goto 0

This will keep the error check close to the code, and any other errors would
be reported in the normal way.
 
Back
Top