change error message when no more for "find" in macro to find

  • Thread starter Thread starter swyltm
  • Start date Start date
S

swyltm

I have a macro in excel which "find"s a value of "FALSE" in a cell. If there
are no cells with "FALSE" in them, I get a "debug" type error message.

I would rather the computer bring up a message saying "Search complete"
 
Back
Top