Posted to microsoft.public.excel.programming

Dale[_13_] Dale[_13_] is offline

external usenet poster

Posts: 2

Data on clipboard message...

Thanks heaps.. Worked a treat.

I knew it was something simple..

Dale

"Jan Karel Pieterse" wrote in message
...
Hi Dale,

I am then asked if i'd like to keep the data on
the clip board for use else where.

How do I stop this message or reply 'NO' in VBA?

Add this line after the paste is done:

Application.CutCopyMode=False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Message: 'Cannot empty clipboard'	Terry Pinnell	Excel Discussion (Misc queries)	2	May 27th 09 09:11 AM
Message: Cannot empty clipboard	Terry Pinnell	Excel Discussion (Misc queries)	2	May 22nd 09 12:39 AM
Clipboard Message	Graham Haughs[_3_]	Excel Programming	2	August 25th 04 08:45 AM
By-passing clipboard message	Ian M[_2_]	Excel Programming	3	May 3rd 04 03:52 AM
How to avoid "large data on clipboard" message?	keith	Excel Programming	4	September 25th 03 08:44 PM

All times are GMT +1. The time now is 08:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us