Attribute VB_Name = "testcelledit5" Sub ƒeƒXƒg() Dim range1 As Range Set range1 = Range("B2:C5") range1.Copy ActiveSheet.Paste Destination:=Range("E2") ActiveSheet.Paste Destination:=Range("B7") Application.CutCopyMode = False End Sub