Posted to microsoft.public.excel.programming

John Wilson John Wilson is offline

external usenet poster

Posts: 550

xlClipboard Clear Contents

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clear Contents	gibbylinks	Setting up and Configuration of Excel	5	October 12th 09 05:04 PM
Macro to clear contents and put an X	bevchapman	Excel Discussion (Misc queries)	3	March 17th 09 07:03 PM
Clear Contents	Secret Squirrel	Excel Discussion (Misc queries)	1	February 3rd 09 12:37 AM
Code to clear contents	jk	Excel Worksheet Functions	3	September 4th 06 06:25 PM
Clear clipboard contents	Cordobes	Excel Discussion (Misc queries)	4	November 22nd 05 02:41 AM

All times are GMT +1. The time now is 06:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us