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.