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.

"Gord Dibben" wrote:

Larry

Application.CutCopyMode = False

clears the clipboard.

Plunk it into your macro after your paste code.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 11:03:18 -0700, Larry
wrote:

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.