Sam,

Try

Application.CutCopyMode = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"sam" wrote in message
...
hi,
does anyone know a function that clears the contents of
the clipboard?

i need to clear it after every copy and paste to avoid a
message that keeps poping up that a large amount of data
is on the clipboard.

thanx