Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm new to Error Handling.
I have a macro that is on a loop controlling two workbooks. On most days everything works fine and there are no issues. Once in a while a worksheet disappears for no reason. I solved that problem by adding code that closes and re-opens the offending worksheet on each interation. Now once in even less of a while, it hangs on re-opening that workbook. I guess it never fully closed before it was told to re-open, but I'm not sure. So, I'd like to insert an "on error" code that closes both workbooks and then fires the marco that starts my loop over again, "Loop" is the name of that macro. Can anyone help me? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling | Excel Discussion (Misc queries) | |||
Worksheet-specific event handling needed | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error Handling | Excel Programming | |||
Error handling with a handling routine | Excel Programming |