There is no limit that I have heard of.

Perhaps the conditions for the find are not being set explicitly and causing
the failure.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
We are experiencing intermittent errors from "Finds" in
our macros. Generally these are when our macros have
performed over 200 searches. The Find suddenly fails
although if the search is performed on the worksheet it
achieves the find successfully. So while the data is
present, the search appears to have grown tired!

Is there a limit to the number of Finds allowed, or do
some buffers need clearing or is there some other solution
other than running the macro in sections to reduce the
volume of searches?

Thanks