title: Refereing to a range of cell in another sheet
body: <p>I am currently trying to use a button to copy all the values inside a range to paste these values inside a range in a different sheet.</p>
  
  <p>Excel gives me an error with the second line of this code:</p>
  
  <pre><code>Sub COPYVALUES()
  Range("Base_Copy!F15:Base_Copy!AK46").Select
  Selection.Copy
  
  Range("F15:AK46").Select
  ActiveSheet.Paste
  End Sub
  </code></pre>
  
  <p>My two sheets are <strong>Base_Copy</strong> where the values are, an i want to paste the into <strong>Final_Copy</strong></p>