on error
 

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
 

On Error applies until you tell it to stop

Use :
On Error Goto 0 to reset to the default error handling


--
If the post is helpful, please consider donating something to an animal
charity on my behalf .......... and click Yes


"joemeshuggah" wrote:

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
 

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.

"Paul" wrote:

On Error applies until you tell it to stop

Use :
On Error Goto 0 to reset to the default error handling


--
If the post is helpful, please consider donating something to an animal
charity on my behalf .......... and click Yes


"joemeshuggah" wrote:

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?