Solved: Deleting contents of clipboard

[jungix]

Hi,

Just a simple question. When I copy and paste with a pastespecial in Excel it works well, but the original data that I copied remain selected at the end, and when I close the workbook I have a warning saying that the contents of the clipboard is too huge, and asking if I want to delete it. How could I do that in a macro, or be able to unselect the copied range?

[Marcster]

This works, if I'm getting what you mean:
Application.CutCopyMode = False
Use this after you've done the the paste special thing.

Marcster.

[CCkfm2000]

see this kb entry.

http://vbaexpress.com/kb/getarticle.php?kb_id=205

[jungix]

Thanks to both of you.

Actually Marcster solution is enough for me here, but I'll remember the kb entry if I need it one day.

[Marcster]

Glad to be able help :yes.

Marcster.

[Zack Barresse]

Btw, there is a large difference between the Windows clipboard, and the Office clipboard (yes, there are two). The API call only affects the Windows clipboard. I don't know if there is a way to clear the Office clipboard. :dunno

[Marcster]

.