Thread: Finding & deleting cells that do not contain a certain text string
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
clmarquez[_2_] clmarquez[_2_] is offline
external usenet poster
  
Posts: 1
Default Finding & deleting cells that do not contain a certain text string

Worked good, except it was deleting the cells that I wanted to keep!
So, I added a "Not" after your "If", and it solved the problem.

Thanks again for the quick reply and solution

--
clmarque
-----------------------------------------------------------------------
clmarquez's Profile: http://www.excelforum.com/member.php...fo&userid=2938
View this thread: http://www.excelforum.com/showthread.php?threadid=49098

Reply With QuoteReply With Quote