Thread: How can I get around "Find" if there's nothing to find
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CarolineHedges[_5_] CarolineHedges[_5_] is offline
external usenet poster
  
Posts: 1
Default How can I get around "Find" if there's nothing to find

I need to my macro to be able to Find certain words and delete the rows
wherever these words occur.

If I use the Cells.Find(????) to locate the words, the macro doesn't
work ifthe word to find isn't in the spreadsheet.

How can I get around the Cell.Find(????), ie to ignore and move on to
the net step if there aren't any more of ??? to find.

This is causing me so much frustration!!!

Thanks


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=555574

Reply With QuoteReply With Quote