Macro to clear clipboard on exit

F

Fan924

In a macro, I do some copying and pasting and would like to exit the
Macro with an empty clipboard. Anyone?
 
G

GS

Fan924 presented the following explanation :
In a macro, I do some copying and pasting and would like to exit the
Macro with an empty clipboard. Anyone?
Click to expand...

Try...

Application.CutCopyMode = False 'clear the clipboard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to restore previous content of clipboard 3
Check if clipboard is empty before pasting 1
Clear Clipboard command in Excel 2007 1
copy and paste and clipboard contents message 3
PasteSpecial method of Range class failed Error 1004 8
Routine Interfering with Clipboard 13
Test if clipboard empty 6
Run Macro If Cell have "x" value 0

Top