Sub Macro1() Dim Rng As Range Set Rng = ActiveCell Rng.Copy ActiveSheet.UsedRange.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False Rng.Select End Sub
Sub Macro1() Dim Rng As Range Set Rng = ActiveCell Rng.Copy ActiveSheet.UsedRange.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False Rng.Select End Sub