dim FoundCell as range

set foundcell = something.find(....)

if foundcell is nothing then
'do nothing
else
foundcell.entirerow.delete 'or whatever
end if

Notice that there won't be a .activate at the end of that .find(...) line.

Karrisac15 wrote:

I am wanting to run a macro to find a certain string of text and I want it to
delete that text if it finds it. Is there any way that I can set it up where
the macro will go to the next section if it does not find what it is looking
for instead of erroring out?

--

Dave Peterson