The standard duplicate process involves two stages: copying data to the system clipboard and pasting it into a new destination. While shortcuts like Ctrl + C (Copy) and Ctrl + V (Paste) are universal, they copy everything—the data, the formula, the cell borders, and the background colours.
sourceRange.Copy destRange.PasteSpecial Paste:=xlPasteFormats Application.CutCopyMode = False l r copy format in excel