title: VBA filter by Array of strings as criteria
body: <p>I have a column that I need to filter and check if a cell contains <strong>any</strong> words from a list.</p>
  <p>If I had a list like this</p>
  <pre><code>Targeted = Array(&quot;Word 1&quot;, &quot;Word 2&quot;, &quot;Word 3&quot;)
  </code></pre>
  <p>I would like to filter and see <strong>any</strong> cell that contains <strong>any</strong> of those words, I thougth something like this would do it:</p>
  <pre><code>Dim Targeted As Variant
  Targeted = Array(&quot;*Word 1*&quot;, &quot;*Word 2*&quot;, &quot;*Word 3*&quot;)
  
  Dim Targeted_ColNum As Integer
  Targeted_ColNum = Range(&quot;1:1&quot;).Find(&quot;Targeted&quot;, , xlValues, xlWhole).Column
  
  Cells.AutoFilter Field:=Targeted_ColNum, Criteria1:=Targeted
  </code></pre>
  <p>But I only seem to be filtering by the last word, so in this example I am only seeing cells that contain the text “Word 3”, as oppose to seeing any cell with “Word 1“ <strong>or</strong> “Word 2” <strong>or</strong> “Word 3” in them</p>
  <p>What am I doing wrong?</p>