title: VBA Filter everything not in the array
body: <p>I have code that filters by everything in an array, however I would like to filter the data by everything not in the array and then delete that information. Any ideas?</p>
  
  <pre><code>    Set rng = Sheets("Input Sheet").Range("B" &amp; Srow &amp; ":" &amp; "B" &amp; Frow)
      i = 0
      ReDim ary(0)
      For Each cell In rng
      ary(i) = cell.Value
      i = i + 1
      ReDim Preserve ary(i)
      Next cell
      ws.Range(Startrow_fil &amp; ":" &amp; Endrow_fil).AutoFilter Field:=Fil_Col, Criteria1:="&lt;&gt;" &amp; ary, Operator:=xlFilterValues' here I get a mistype error because of the "&amp;"
      End If
  </code></pre>
  
  <p>The code works perfectly when filtering by the array, in other words, keep everything in the array. </p>