Application.CutCopyMode = False

If you use copy and paste while recording a Macro, you will see the code which refers to Application.CutCopyMode = False.  You may wonder why it’s there? The recorded code looks a bit like this: Range(“A1:A10”).Select Selection.Copy Range(“D1”).Select ActiveSheet.Paste Application.CutCopyMode = False If you use VBA to copy and paste without that line of code, Read More