skiping sections in a macro

K

Karrisac15

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

Jim Thomlinson

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

Dave Peterson

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.
 
Top