title: How do I copy a filtered range into an array? (Excel VBA)
body: <p>I use this formula to copy unique records from Column A into Column B.</p>
  
  <pre><code>Range("A1", Range("A100").End(xlUp)).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("B1"), Unique:=True
  </code></pre>
  
  <p>Instead of copying it into Column B how do you put the filtered results into an array in Excel VBA?</p>