From Chip Pearson:

http://www.cpearson.com/excel/clipboar.htm

Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Sub

If you just want to clear the clipboard of stuff that you've put there using
Excel's Copy function, you can simply use:

Application.CutCopyMode = False

--

Vasant

"scottnshelly " wrote in
message ...
Hey,
i need to have a code that will empty my clipboard. any suggestions?
i got as far as application.clipboardformats....
Thanks


---
Message posted from http://www.ExcelForum.com/