How do I Clear the Contents on the clipboard. I have
tried using Application.CutCopyMode = False, but it does
not clear the clipboard.

Any help would be appreciated.

On you worksheet click view toolbar and select clipboard. There is a
Icon on it that will delete the clipboard contents.

HTH

Charle

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

that will work if you copied cells to the clipboard.

You can use the API for others.

Previously posted by Chip Pearson:

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

Sub ClearClipboard()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub

--
Regards,
Tom Ogilvy

"Ronbo" wrote in message
...
How do I Clear the Contents on the clipboard. I have
tried using Application.CutCopyMode = False, but it does
not clear the clipboard.

Any help would be appreciated.