title: Excel Macro to copy, delete and paste without losing the copy values
body: <p>I'm trying to paste some values that I've previously copied, but I'm losing the data as I am clearing the destination cells beforehand.</p>
  
  <p>This is an example of the code:</p>
  
  <pre><code>Range("A1:B3").Select
  Selection.Copy
  Range("C1:D3").Select
  Selection.ClearContents 'At this point the clipboard is cleared
  Range("C1").Select
  ActiveSheet.Paste 'I get an error here as the clipboard has been cleared
  </code></pre>
  
  <p>Considering that I cannot clear the contents first, is there a way to store the contents of Range("A1:B3") so that I can paste it later? </p>