On Error GoTo 0 ' Have you tried this in place of "Err.Clear"?
--
Best wishes,

Jim


"David" wrote:

> 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