Clear Clipboard

[MD]

Is there a code that will clear up EXCEL's clipboard other than
Application.CutCopyMode = false
or a cope that will prevent the clipboard to jam-up with large amounts of
data

Thanks

Michel

 

[John McGimpsey]

You could use a Data Object. This is necessary in MacXL since it uses
the Mac system clipboard, which isn't cleared by CutCopyMode. The code
will work for WinXL as well.

Take a look at

http://www.mcgimpsey.com/macoffice/excel/clearclipboard.html