title: Excel VBA pastes modified value instead original one
body: <p>My macro below inserts value (Hello) into cell A1 and copies this value using copy method. Then it changes value in A1 (Hi).</p>
  
  <p>At the end I would like to paste (original) value into another cell e.g. B1. 
  I'm very surprised that Excel pastes modified value instead original one (why? copying has been before modifying!).</p>
  
  <p>Notice: My macro starts with CopyAndPasteData().</p>
  
  <pre><code>Sub CopyAndPasteData()
    Range("A1") = "Hello"
    CopyData
    Range("A1") = "Hi"
    PasteData
  End Sub
  
  Sub CopyData()
    Range("A1").Copy
  End Sub
  
  Sub PasteData()
    Range("B1").PasteSpecial
  End Sub
  </code></pre>