Stop Macro when find fails
This was asked under General topics, but no response.
I have a simple Macro that finds a term and deleted the line containing that term.
But, after the last instance of that term was found, the Macro then proceeds to delete the remaining lines until it reaches the end of the file.
How to stop the Macro when it no longer can find the search term?
@Vance-Neff I’ve also had some surprising behavior when deleting or moving lines in macros.
I suggest you abandon this approach, and instead, use a regex F&R to match a complete line containing the term, something like:
and then, make sure the Replace with field is properly empty (no spaces).
Use Replace a few times to satisfy yourself replacements are being done as expected, then Replace All to act on the whole file.