title: Excel VBA get a range value from visible cells after applying autofilter
body: <p>Is it not possible to do something simple like this to get the range value of B2? </p>
  
  <pre><code>crdata.Range("B2").SpecialCells(xlCellTypeVisible).Value
  </code></pre>
  
  <p>I have applied the autofilter to filter out with the given criteria and trying to return the range of B2 as a function. </p>