title: VBA paste range
body: <p>I would like to copy a range and paste it into another spreadsheet. The following code below gets the copies, but does not paste:</p>
  <pre><code>Sub Normalize()
  
      Dim Ticker As Range
      Sheets(&quot;Sheet1&quot;).Activate
      Set Ticker = Range(Cells(2, 1), Cells(65, 1))
      Ticker.Copy
      
      Sheets(&quot;Sheet2&quot;).Select
      Cells(1, 1).Activate
      Ticker.PasteSpecial xlPasteAll
      
  End Sub
  </code></pre>
  <p>How can I paste the copies into another sheet?</p>