title: Copying a range without activating the sheet
body: <p>I'm having a bit of trouble understanding how to copy a range without activating the sheet that the range is on.</p>
  
  <p>This code works:</p>
  
  <pre><code>With Sheet6
    .Range("A1", .Cells(.Cells(Rows.Count, "B").End(xlUp).Row, "P")).Copy
  End With
  </code></pre>
  
  <p>but none of the below lines work:</p>
  
  <pre><code>Sheets(6).Range("A1", Cells(Cells(Rows.Count, "B").End(xlUp).Row, "P")).Copy
  Sheet6.Range("A1", Cells(Cells(Rows.Count, "B").End(xlUp).Row, "P")).Copy
  
  Sheets(6).Range("A1", .Cells(.Cells(Rows.Count, "B").End(xlUp).Row, "P")).Copy
  Sheet6.Range("A1", .Cells(.Cells(Rows.Count, "B").End(xlUp).Row, "P")).Copy
  </code></pre>
  
  <p>I'm probably missing something simple here but it seems like a lot of unnecessary code to use <code>With</code> for one action.</p>