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/e...clipboard.html

In article ,
"MD" wrote:

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