Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm trying to create a simple macro to move cells to different positions in relation to the ActiveCell position. The Cut works fine. The I don't understand why the Paste or PasteSpecial fail?
Sub CopyAcross()
ActiveCell.Offset(1, 0).Cut
ActiveCell.Offset(-1, 1).Paste 'or PasteSpecial
ActiveCell.Offset(2, 0).Cut
ActiveCell.Offset(0, 2).Paste
ActiveCell.Offset(3, 0).Select 'Move to the next section
End Sub