Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The On Error Error
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |