title: VBA - How to AutoFilter on same field for more than two criteria?
body: <p>I've been searching for an answer all day and can't seem to find a solution to my issue. The closest thing I found to my problem is this link right here:</p>
  
  <p><a href="https://stackoverflow.com/questions/21834701/use-autofilter-on-more-than-2-criteria">Use autofilter on more than 2 criteria</a></p>
  
  <p>This is my worksheet:</p>
  
  <p><a href="https://i.stack.imgur.com/RMnpH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RMnpH.png" alt="My Worksheet"></a></p>
  
  <p>That, however, doesn't solve my problem. I've been using the answer from that question as a basis in my searching. I'm not getting any errors, but when I run the code it filters out rows 6-35 (the whole thing!).</p>
  
  <pre><code>Dim calc as Worksheet
  Dim lastrow as Integer
  
  Set calc = ThisWorkbook.Sheets("Calc")
  lastrow = Application.CountA(Range("A6:A" &amp; Rows.Count)) + 5
  
  calc.Range("A5:T" &amp; lastrow).AutoFilter _
       Field:=4, _
       Criteria1:=Array(3410, 3420, 3440, 3450, 3490, 1445), _
       Operator:=xlFilterValues
  </code></pre>
  
  <p>I've also tried the same code but without the "Operator" part of it and it actually filters for the two rows (rows 6 and 20) with the last criteria in the Array (1445). But why not for the rest? I'm so lost and I've been searching for hours. I feel like this SHOULD be straight forward.</p>