Disable Clipboard Dialog Box during Macro

T

Tom

Hi All-

I have a vba program that runs through multiple
iterations via a loop statement. After some point,from
copying and pasting, the clipboard becomes full
and a dialog box appears that asks if I want to save
contents for another program or do I want to delete the
contents. I have to hit the no button multiple times
because it is looping through many iterations. I have
tried using xlClipboard.Clear but I get an error that says
I have an invalid qualifier. I have also used
Application.CutCopyMode = False and it does not work. Any
suggestions on how I can control the xlClipboard and set
it so that it clears all contents on each loop.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top