Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Group,
I am doing several Find procedures in a module. I do not always expect to Find the text so I get a 91 error. The first instance of the error is handled by an error procedure "On Error GoTo ErrorHandler" where I clear the error ErrorHandler: Err.Clear This is fine, but I am repeating the Find procedure several more times and can not predict where and when it might fail again. Subsequent failures do not allow me to use another "On Error GoTo ErrorHandlerTwo", note the different name. I can not use a Resume Next, becasue on a failure I need to skip certain code steps, so I want to continue the code after the ErrorHandler or ErrorHandlerTwo or Three, etc. Suggestions would be appreciated. It maybe that I have to Dim and Set, but I am not sure how to do this for each possible instance of a Find failure. Thanks -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
how to find an error | Excel Discussion (Misc queries) | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
change error message when no more for "find" in macro to find | Excel Programming | |||
Can someone find this error? | Excel Programming |