I will give that a go next time the problem occurs, however, I doubt that is
the answer, as it performs a very simillar find with the same settings on a
very simillar piece of date 10 lines before the problem line! And why won't
it work properly again until the Application is reStarted, simply reStarting
the workbook makes no differance!




Tom Ogilvy wrote in message
...
Find has several persistent values. You are only setting the search
target,
so some previous use of find could set one of the other values so that the
find is not made. xlwhole vice xlpart, xlformulas vice xlvalues for
example can affect whether the target is found. If it is a date, then
it
can get even more complicated.


--
Regards,
Tom Ogilvy