title: Runtime error 1004 when using Cut and PasteSpecial
body: <p>I have to cut the contents from active cell for a specific range in sheet 1 and paste it into the active cell of that range in sheet 2. Cutting the specific range of contents is working fine, but in the paste options I am getting runtime error 1004 as application defined or object defined error.</p>
  
  <p>Here is the code I am using:</p>
  
  <pre><code>Sub sheet1_sheet2_copy_click()
    Sheets("sheet1").Activate
    ActiveCell.Resize(1, 26).Cut
    Sheets("sheet2").Activate
    ActiveCell.Resize(1, 26).PasteSpecial
  End Sub
  </code></pre>