Hi Chip,

Thank you for the correction and elucidation.

---
Regards,
Norman



"Chip Pearson" wrote in message
...
Application.CutCopyMode=False

This doesn't clear all the data in the clipboard, only Excel data. Text
will remain. To fully clear the clipboard, use

Declare Function CloseClipboard Lib "user32" () As Long
Declare Function EmptyClipboard Lib "user32" () As Long
Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long

Sub AAA()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub

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



"Norman Jones" wrote in message
...
Hi Avi,

Try:

Application.CutCopyMode=False

---
Regards,
Norman



"Avi" wrote in message
...
Hello,

I'm looking for some API or othe method for clearing the clipboard in
Excel 2003


Thanks,




Avi Benita 054-4660641 wwwAvi Benita 054-4660641 www.avibenita.com