title: Delete row based off multiple criteria
body: <p>I am trying to delete certain rows in my excel sheet, based on the value of a cell in row H. I am trying to write a code so if it finds the word "deleted" or "processing" "random". </p>
  
  <p>Right now I have a code that will look through the entire sheet and delete the row based off of one value, but is there an easy way to code it so that it can look for more than one?</p>
  
  <p>My current code:</p>
  
  <pre><code>Dim r As Long, endRow As Long, pasteRowIndex As Long
  
  endRow = 100 ' of course it's best to retrieve the last used row number via a function
  
  For r = 1 To endRow 'Loop through Open Orders and search for my criteria
  
  If Cells(r, Columns("H").Column).Value = "VARIABLE" Then 'Found
  
          'Copy the current row
          Rows(r).Select
          Selection.Delete
  
      End If
   Next r
  </code></pre>
  
  <p>This works great if I am only looking for the one value "variable" but I can't seem to figure out how to make it search for more than one at a time.</p>