title: Copy a range from one worksheet to another using cells property
body: <p>I am trying to copy a range from one worksheet to another.  I have multiple ranges that I would like to copy and paste at various points in the new worksheet though (for example, I want to paste the first range to D3, then the next range to E12, and so on), so I am using the cells property to describe the range.  However, for some reason, when I describe the range that I want to paste at in the new worksheet using the cells format rather than just putting in a string, it does not work.</p>
  
  <p>This line of code does work:</p>
  
  <pre><code>Sheets("Sheet1").Range(Cells(2, 3), Cells(10, 3)).Copy _
    Destination:=Sheets("Sheet2").Range("D3")
  </code></pre>
  
  <p>but this one does not:</p>
  
  <pre><code>Sheets("Sheet1").Range(Cells(2, 3), Cells(10, 3)).Copy _
    Destination:=Sheets("Sheet2").Range(Cells(3,4))
  </code></pre>
  
  <p>When I run the latter line of code, I get a "Run-time error 1004: application-defined or object defined error".  Why is this and how can I fix it?</p>