title: VBA - copy filtered range without select
body: <p>I have a range of data and I want to filter by specific criteria and then copy the filtered data to another sheet.</p>
  
  <p>This is my code:</p>
  
  <pre><code>           'filter and Lastrow are variables previously declared    
              Sheet1.Activate
              Sheet1.Range("$A$1:$AW$" &amp; Lastrow).AutoFilter field:=1, Criteria1:=filter
              Sheet1.Range("A1").Select
  
              Range(Selection, Selection.End(xlDown)).Select
              Range(Selection, Selection.End(xlToRight)).Select
              Selection.Copy Destination:=Sheet2.Range("A1")
  </code></pre>
  
  <p>The problem is that this requires selecting and selecting requires the relevant sheet to be active.
  Is there a way to do it without first selecting (Sheet1.Range("A1").select)?
  Note, that my filtered range is not a table.</p>
  
  <p>Thanks!</p>