can i supress "can't find the data" dialogue box with FORMULA.FIND and FORMULA.REPLACE?

i'm looking for a FALSE return value from these functions if they can't find the data. I don't know if i get that as well, but currently, macros just interrupted by dialogue box that says "Microsoft Excel can't find the data you are looking for".

i'd like to supress that response and simply have the function return FALSE if possible.

thanks,

brian

a couple examples

Please Login or Register  to view this content.

so i'm looking for a word and deleting it but since i don't know how many occurences there are other than less than 10 so sometimes the function bogs down because i get a dialogue box that says "Microsoft Excel cannot find the data you are looking for" and I have to manually clear that each time it comes up. I don't know of an argument to that function that can suppress that return. I would have assumed if it can't find what you are looking for it would return FALSE.

another way up the same mountain which gives me less dialogue boxes but doesn't get me out of this altogether

Please Login or Register  to view this content.

that replaces all instances of purchases with nothing but it returns a dialogue box telling me the number of replacements it made so it doesn't allow the macro to execute without my input. similar kind of problem. don't know if there is a way from within these functions or prior to executing them that i can turn off the dialogue box response. this is further complicated for folks to respond to, because, as you can see, i write in XLM.

thks,

brian