Attribute VB_Name = "testcelledit1" Sub ƒeƒXƒg() Dim range1 As Range Set range1 = Range("C2") range1.Delete Shift:=xlShiftToLeft Range("C3:D4").Delete Shift:=xlShiftUp End Sub