I have a workbook with multiple sheets that I'm trying to use a macro to find
and pull any matches and place them on a new "results" sheet. The way it's
set now i have a seperate "search" sheet setup to have a specific cell used
for the phrase to find and option boxes to check which sheets get searched.
It runs fine till it gets to a sheet that doesn't have a match and it stops
the macro and asks to end/debug the macro. Is there a way to incorporate the
find method into an if statement or something else that if no matches are
found it goes to the next part of code?