Macro to clear clipboard on exit

  • Thread starter Thread starter Fan924
  • Start date Start date
F

Fan924

In a macro, I do some copying and pasting and would like to exit the
Macro with an empty clipboard. Anyone?
 
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
PasteSpecial method of Range class failed Error 1004 8
Test if clipboard empty 6
how do i empty the clipboard from within an excel macro 5
paste special macro stops working when run a 2nd time 1
Run Macro If Cell have "x" value 0

Back
Top