title: Silly Error that's killing me. Method Range of Object failed lol
body: <p>I have these two lines of code. Both are range variables, set the same way using the same variables for <code>lastrow</code> and <code>lastcol</code> both hold the correct values. The worksheets are in the same workbook. The first range is set fine. The second throws an error. <code>Method 'Range' of Object '_Worksheet' failed.</code>. As you can see I am trying to set the range values equal.  I feel like this error normally occurs because the range isn't fully qualified...any ideas here?</p>
  <pre><code>
  Set csvrng = mm.Range(Cells(1, 1), Cells(lastrow, lastcol - 2))
  Set wksrng = wks.Range(Cells(1, 1), Cells(lastrow, lastcol - 2))
  
  csvrng.Value = wksrng.Value
  </code></pre>
  <p>Also tried:</p>
  <pre><code>mm.Range(Cells(1, 1), Cells(lastrow, lastcol - 2)) = wks.Range(Cells(1, 1), Cells(lastrow, lastcol - 2))
  </code></pre>
  <p>Also used the <code>.value</code> for each range. Same error on the <code>wks</code> worksheet each time.</p>
  <p>UPDATE:
  <code>ActiveSheet</code> will not solve this since I have worksheet variables set. @Ike was dead on though. I needed to fully qualify my <code>Cells</code> reference.</p>