title: Which is a faster copying method? Excel VBA
body: <p>I'm going to be repeating part of a VBA module many times and I want to make sure I'm doing this the most efficient way. Most efficient meaning the quickest loading time.</p>
  
  <p>Basically, I'm copying data from a range on wb2 and pasting it to a wb1 destination.</p>
  
  <p>The first method seems easier as it's shorter:</p>
  
  <pre><code>wb2.Sheets(1).Range(Cells(2, TrpCdBLCol), Cells(100, TrpCdBLCol)).Copy wb1.Sheets("BL Import").Cells(2, TrpCdCol)
  </code></pre>
  
  <p>The second method I declare two variables as ranges, set them, and the copy</p>
  
  <pre><code>Dim CopyRange As Range, Dest As Range
      Set CopyRange = wb2.Sheets(1).Range(Cells(2, TrpCdBLCol), Cells(100, TrpCdBLCol))
      Set Dest = wb1.Sheets("BL Import").Cells(2, TrpCdCol)
      CopyRange.Copy Dest
  </code></pre>
  
  <p>Is there any difference or is one way better than the other?
  Thanks!</p>