title: Exce: VB command to copy a range of cells from one sheet to another sheet
body: <p>I have 2 sheets (calculator &amp; backupschedule) in the same file and i am transferring data to and fro between the sheets. </p>
  
  <p>I am having trouble figuring out how to transfer a range of cells from the calculator sheet to the other.</p>
  
  <p>My current VB code is :</p>
  
  <pre><code>Sheets("Calculator").Range("R3:R15").Copy Destination:=Sheets("BackupSchedule").Range("E8:E20")
  </code></pre>
  
  <p>but i get an #REF! error in the backupschedule sheet in the cells E8:E20.</p>
  
  <p>I want to copy the cells in Column R, Row 3 through 15 (Cells: R3,R4,R5,etc) and then place them in column E rows 8 through 20 (Cells: E8,E9,E10, etc)</p>
  
  <p>Can someone give me a hand with this please?</p>