- Apr 24, 2024
Excel VBA Command to Clear the Clipboard
- Neale Blackwood
- Macros, Tips & Shortcuts
- 0 comments
When using copy and paste in a VBA macro it is a good idea to clear the clipboard at the end of the macro. If you don’t, the user could use paste to paste the last thing you had copied in the macro.
Sign up to hear about free Excel training.
I won't share your email with anyone.
Luckily it is easy to clear the clipboard in VBA.
It’s a one line command.
Application.CutCopyMode=FalseUsually you place this command near the end of your macro.
You can also include it after each paste in your code to make sure the clipboard is cleared between each copy and paste.
If you use error handling code you would place the command with all the code to run when the macro finishes.