I want to duplicate the format style in the range [A3:I6] to range [A7] & the last row. I am having a problem with the code below?
Thanks in Advance
![]()
Range("A3:I6").Range("A7:I" & LastRow).PasteSpecial Paste:=xlPasteFormats Application.CutCopyMode = False
Bookmarks