Attribute VB_Name = "testcelledit7" Sub ƒeƒXƒg() Dim range1 As Range Set range1 = Range("B2:C5") range1.Copy Range("E2").PasteSpecial Paste:=xlPasteFormats Application.CutCopyMode = False End Sub