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?

Yup, we can help you avoid the error... But post your code so we can see what
you are up to.
--
HTH...

Jim Thomlinson


"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?

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