title: VBA Autofilter Using Multiple Criteria
body: <p>All, </p>
  
  <p>I am trying to filter on multiple criteria within VBA.</p>
  
  <p>However I cannot find a simple way of doing this. The criteria I am selecting will always be constant but greater than 2 therefore I cannot use the or operator. </p>
  
  <p>Code below;</p>
  
  <pre><code>Selection.AutoFilter field:=10, Criteria1:=Array("Fixtures &amp; Fittings", "Furniture &amp; Equipment", "Land &amp; Buildings", "Motor Vehicles", "Plant &amp; Machinery")
  </code></pre>
  
  <p>My current solution only filters on the last criteria within the array.</p>
  
  <p>Due to the file set up I am unable to insert a formula in another column. </p>
  
  <p>Thanks</p>