title: Moving a Range after pasting
body: <p>So I am looking to have a button that on clicking copies and pastes a range from one sheet to another and on subsequent clicks the data would be pasted with out overwriting the data from the previous paste. I've written this code so far but I'm stuck on how to change where data would be pasted.</p>
  
  <pre><code>  Sub CommandButton1_Click()
      Application.ScreenUpdating = False
      Static cnt As Long
      cnt = cnt + 1
      Me.CommandButton1.Caption = "I have been clicked " &amp; cnt &amp; " times"
      Worksheets("Main").Range("A1:J13").Copy
      Worksheets("Secondary").Range("A1:J13").PasteSpecial xlPasteValues
      Application.ScreenUpdating = True
  End Sub
  </code></pre>