JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
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?
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]