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
 
Top