Tom,

That code should be placed directly after the paste operation.
Actually, better to place it after each paste operation.
If it's not working, post the section of your code where you're getting
the alert.

While the pop-up help shows you xlCut and xlCopy, using False should
clear the clipboard.

John

Tom wrote:

John,

When I put in Application.CutCopyMode I get two options
after the CutCopyMode which are xlcut or xlcopy. I ran the
program with Apllication.CutCopyMode = False and the
dialog box still came up saying the clipboard if full, do
I want to save or not. Any more Suggestions?

Thanks,
Tom
-----Original Message-----
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

.