Status bar returns to its default status.

Press Esc key to leave CutCopyMode without needing to perform an action on the worksheet.Īpplication.CutCopyMode = False is the VBA action of leaving cut/copy mode.

Perform any other action to leave the cut/copy mode.

Paste the copied content from the clipboard, or.

Look at the screenshot below the marching ants show that we are in cut or copy mode, with cells A1 to C4 stored in the clipboard. The message in the status bar also changes to indicate which mode we are in. In Excel, when we copy or cut a range of cells, the content is temporarily stored in Excel’s clipboard. This is when the animated dotted line appears and moves around the outside of the range commonly referred to as the marching ants. If we run the VBA code to copy and paste without that line of code, it still works fine. So, does it serve any purpose? What is Application.CutCopyMode = False for?

If we record a VBA Macro where we copy and paste the recorded code might look similar to the following: Range('A1:A10').Select

Will Application.CutCopyMode clear the clipboard?Īpplication.CutCopyMode = False in recorded macros.

What is Application.CutCopyMode = False for?.Application.CutCopyMode = False in recorded macros.

Excel clear clipboard mac