office clipboard

L

Larry

Is there a way to clear the office clipboard using VBA. I am making some
large copies in a macro and it eventually freezes my system.
 
G

Gord Dibben

Larry

Application.CutCopyMode = False

clears the clipboard.

Plunk it into your macro after your paste code.


Gord Dibben MS Excel MVP
 
L

Larry

Thanks for your reply. I have tried that and it isn't clearing the
clipboard. Could I have sometning in the setup that prevents this.
 
G

Gord Dibben

Larry

If you're still there, try this......

Sub ClearClipboard()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy unformatted value of cell via macro 0
Pasting from the clipboard 3
Excel 2003 Clipboard 0
Range.Copy [Destination] should not use clipboard 0
XL 2003 very slow to Copy. XP SP3 2
How to copy/paste without using clipboard? 11
The picture is too large and will be truncated 1
Copy/Paste (Clipboard) Issues 1

Top