Macro based on ActiveCell.Offset

Dave Wilcox 0 Reputation points
2023-05-02T13:55:06.0266667+00:00

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

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.