title: VBA AutoFiltering using multiple variable
body: <p>I have a problem using my autofilter. I need to filter sever values at a time.
  I have the list of values on first sheet (column I2:I50) and on the second sheet I would need to filter all these values from database.</p>
  
  <p>My code so far is:</p>
  
  <pre><code>   Dim OZ As Variant
  
     OZ = Array("100001", "100015")
  
     Sheets("Sheet2").Select
     Range("A1:M1").AutoFilter Field:=3, Criteria1:=OZ, _
     Operator:=xlFilterValues
  </code></pre>
  
  <p>This works perfectly so far. Now I am strugeling to setup the macro in a way, so the array refers to the Range of Sheet1 and I2:I50. Values in this range are variables calculated by functions.</p>
  
  <p>Can you please help me with that?.</p>
  
  <p>Thanks</p>