How to clear the clipboard in my Excel VBA Code?

Every now and again we need to clear the clipboard from our Excel VBA code.

This can be for one or more reasons. The most common is that we pasted the content of the clipboard, and we need to free up the memory. This will bring you stability, to your code.

It is a simple procedure, really just a line of code:

Application.CutCopyMode = False

But please be aware that this line of code only clears the windows system clipboard. Excel has another one within.

Did you know that ExcelAngel have a facebook page. Come and visit us!

You can find more Excel VBA tutorials in this category

[et_pb_ccfcm_facebook_comments_module ccfcm_app_id=”339898187197719″ _builder_version=”4.6.1″ _module_preset=”default”][/et_pb_ccfcm_facebook_comments_module]