title: Excel VBA find multiple values in one cell
body: <p>I have some code to search for a value in a cell and then do something if that value is found. My text step is to search for two values in one cell. If the two values are found do something.</p>
  
  <p>This is my code for searching for 1 value;</p>
  
  <pre><code>Dim C As Range
  Set SrchRng = ActiveSheet.UsedRange
  Do
      Set C = SrchRng.Find("Wash", LookIn:=xlValues)
      If Not C Is Nothing Then C.EntireRow.Delete
      Loop While Not C Is Nothing
  </code></pre>
  
  <p>My question is how can I adapt this to look for two words instead of one?</p>
  
  <p>For example cells may contain</p>
  
  <p>"The cat sat on the matt"</p>
  
  <p>I need to find cells with the word cat and matt.
  I have spent a long time looking online for how do do this but nothing I find seems to help.</p>
  
  <p>Thanks in advance!</p>
  
  <p>I</p>