Tom,

Application.CutCopyMode = False
should do the trick

John

Tom wrote:

Hi Guys-

I have a vba program that runs through multiple
iterations. After some point the clipboard becomes full
and the dialog box comes up asking if I want to save
contents and I have to hit the no button. I have tried
using xlClipboard.Clear but I get an error that says I
have an invalid qualifier. Any suggestions on how I can
control the xlClipboard and set it so that it clears
contents on each loop.

Thanks