Does Application.CutCopyMode = False clear the Excel clipboard or not? Confused.

[d0rian]

I've gotten in the habit of pasting Application.CutCopyMode = False at the end of nearly any VBA code that executes any kind of Copy/Paste function, since I read somewhere that it essentially clears any items from the Clipboard / releases any memory associated with it (and I'm often doing quite large copy/paste tasks, e.g. 10K rows of data).

But in trying to troubleshoot a weird Excel hang, I read that it could be related to too much data in the clipboard, which didn't make sense b/c I thought the Application.CutCopyMode = False cleared that...but I opened the Clipboard pane on the left-side of my Excel window and lo and behold see 6 items in there.

So is Application.CutCopyMode = False not actually clearing the Excel clipboard after all? Is there some other VBA code I need to run in order to do so?

 

[bobsan42]

Well, it does clear the system clipboard.
But Excel has an additional one which can store multiple items and can put them back in the clipboard later on.
At the moment I am clueless how one can control this.

[TABLE="width: 64"]
<tbody>[TR]
  [TD="width: 64"]Application.DisplayClipboardWindow=True[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

It's not a simple task to clear the Office clipboard: https://www.mrexcel.com/forum/excel-questions/1087948-reset-clear-clipboard.html