Excel clearing clipboard

G

Guest

When I copy stuff from Excel 2000, SP-3 to the clipboard, Excel often
clears the clipboard so that when I go to use the copies material it is no
longer there.

How can I prevent Excel from automatically clearing the clipboard.

Thanks.
 
C

Chip Pearson

You can't prevent Excel from clearing the clipboard. The best
practice is to copy the range immediately before pasting it,
without other code running between the two operations.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

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

Similar Threads

Clearing Office clipboard 2010 2
Macro to restore previous content of clipboard 3
Copy & Paste & Clipboard in Vista Excel 9
PasteSpecial method of Range class failed Error 1004 8
Clear Clipboard command in Excel 2007 1
Stop Excel from clearing clipboard? 1
paste from clipboard after delete cells 1
Possible bug with clipboard data? - Need Advice 4

Top