Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Error reset?
I'm using the On Error Goto code (see below).
On Error GoTo StopError The StopError routine is as follows: StopError: Msg = "There appears to be no data for this model. (" & model & ") Click OK to continue and then verify that there were no calls for that particular model last month." ' Define message. Style = vbOKOnly ' Define buttons. Title = model ' Define title. Response = MsgBox(Msg, Style, Title) GoTo Repeat This macro loops several times. Each time, I need to be able to keep the "On Error GoTo StopError" active. For some reason, the second time an error occurs, I just get the error instead of the code re-routing to the StopError routine. I've tried adding "On Error Goto 0" before the "GoTo Repeat" statement with no success. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab Key reset | Excel Worksheet Functions | |||
How do I reset the tab key? | Excel Discussion (Misc queries) | |||
Reset Counter | Excel Discussion (Misc queries) | |||
using % button gives error "percent style not found" Can I reset? | Excel Discussion (Misc queries) | |||
reset to zero | Excel Worksheet Functions |