Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find errors
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find errors in documents | Excel Discussion (Misc queries) | |||
Find and Replace Lookup errors | Excel Discussion (Misc queries) | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
To find errors | New Users to Excel | |||
Find finds nothing, and errors | Excel Programming |