title: VBA Excel ERROR 1004 problems with Paste Value
body: <p>I am kind of new with <code>VBA</code> and I have a problem I cannot solve and cannot find the right solutions in earlier questions. In fact it looks quite simple. I want to copy a range in worksheet with the name <code>"Blad3"</code> and paste the values in in worksheet with the name <code>"Blad1"</code>. This is what I made and where does it go wrong?</p>
  
  <pre><code>    ActiveSheet.Cells(dattel, 4).Select
  
      ActiveCell.Range("A1:J1").Copy
  
      Sheets("Blad1").Select
      Cells(8 + aantkk, 6).Select
      ActiveSheet.Unprotect
  '    ActiveCell.PasteSpecial xlPasteValues
      Selection.PasteSpecial Paste:=xlValue
  '    ActiveSheet.Paste
  
      ActiveSheet.Protect
  </code></pre>