title: Cannot select autofiltered table data using VBA
body: <p>I have a table with products I apply an autofilter and I get my filtered products</p>
  
  <pre><code>Set tbl = Worksheets("FOR EXPORT").ListObjects("MyTable")
  'SET AUTOFILTER
  tbl.Range.AutoFilter Field:=3, Criteria1:="&lt;&gt;*ERROR*"
  </code></pre>
  
  <p>I want to filter the products copy them to an array to be able to export them to a CSV</p>
  
  <p>So I try to select the filtered products like </p>
  
  <pre><code>Dim VisRng As Range
  ' set the new Range object to the visible cells of `tbl.Range`
  Set VisRng = tbl.Range.SpecialCells(xlCellTypeVisible)
  ' copy only the visible cells in range to array
  tblArr = VisRng.Value
  </code></pre>
  
  <p>If I add <code>tbl.Range.SpecialCells(xlCellTypeVisible).select</code> it asks for an object</p>
  
  <p>Even if there are about 362 filtered products I get only 196</p>
  
  <p>How to copy the filtered data to variable <code>tblArr</code>? Why I get less products?</p>