The On Error Error

[Guest]

OK

I have code similar to the following:

Sub Number1()

For K = 1 to 40

Do this

On Error GoTo SkipTable

What would have happened if there had been no error

SkipTable:

Next K

Number2

End Sub

Sub Number2()

For L = 1 to 40

Do this

On Error GoTo SkipChart

What would have happened had there been no error

SkipChart

Next L

End Sub

--------------

This works fine til it reaches the second sub (which is near identical to
the first) and then any errors refuse to be trapped and inconveniently cause
the code to halt.

Any ideas? I'm lost.

TIA!

Nick Shinkins

 

[Otto Moehrbach]

Nick
You told Excel to go to SkipTable when any error is encountered. It
will do that every time thereafter unless you tell it to go back to normal.
You do that with something like:
On Error GoTo 0
Put this line after the line where the error is expected to occur. This
line tells Excel to revert to normal error behavior. HTH Otto

 

[Dave Peterson]

You had an alternate suggestion at your first post.