title: Excel remove rows that have certain words in a column
body: <p>I am new to excel scripting/macroing</p>
  
  <p>I have a massive excel sheet and I need to remove some rows from it.</p>
  
  <p>Any rows that have the words: cat, dog, horse, fish</p>
  
  <p>Have tried something like this (as well as quite a few other atempts).</p>
  
  <pre><code>Sub DeleteRows() 
      Dim c As Range 
      Dim SrchRng 
  
      Set SrchRng = ActiveSheet.Range("A1", ActiveSheet.Range("A65536").End(xlUp)) 
      Do 
          Set c = SrchRng.Find("dog","cat","horse","fish", LookIn:=xlValues) 
          If Not c Is Nothing Then c.EntireRow.Delete 
      Loop While Not c Is Nothing 
  End Sub 
  </code></pre>
  
  <p>Some details (since I am unsure what information is truely needed).</p>
  
  <p>These words would always be in the 2nd column (but it could be something like "The George fish" and it would need to remove that row.</p>
  
  <p>Any help would be great, thanks!</p>