title: SpecialCells(xlCellTypeVisible) not returning all values to array (Excel 2013)
body: <p>I have a range with 170000 rows in it. I'm filtering column A for a single value and returning the corresponding values in column B.</p>
  
  <p>I want these values to dump into an array so I can quickly toss them into a dictionary (with the key being the value I filtered column A with).</p>
  
  <p>The problem is that <code>SpecialCells(xlCellTypeVisible)</code> is acting inconsistent.</p>
  
  <p>If I do the same test on a smaller range, the values dump into the array just fine. But with a range as large as mine, it only returns the first value in the range. Also, I can use the same line to copy to another sheet. I just can't get it to populate the array.</p>
  
  <pre><code>foo = ws1.Range(tbl1Name &amp; "[ID]").SpecialCells(xlCellTypeVisible)
  </code></pre>
  
  <p>Works with small ranges, but returns only the first result in a range as large as mine (less than 50 results.) foo becomes an array containing all the variables.</p>
  
  <pre><code>ws1.Range(tbl1Name &amp; "[ID]").SpecialCells(xlCellTypeVisible).Copy ws2.Range("A1")
  </code></pre>
  
  <p>Works with the large range and copies all the relevant data successfully.</p>
  
  <p>So my question: How do I populate the array without the extra step of copying to a blank worksheet when autofiltering a large table range? (Excel 2013)</p>