Excel 2003 - VBA - Eliminate Clipboard Message

C

C Brandt

I copy a sheet from another workbook and paste it in the target workbook. I
then close the source and get a message about a large amount of data on the
clipboard.

Is there a way to supress this message or clear the clipboard?

Thanks

Craig
 
O

Otto Moehrbach

Hit the Esc key. In VBA, insert the following line into your code:
Application.CutCopyMode = False
HTH Otto
 
C

C Brandt

Otto:

As soon as I figured out where to put the code in the routine, it worked
like a charm.
I noticed that sometimes I ended up in a mode where the select cells was
kind of stuck midstream, now I know what to look for to fix that condition.

Thanks,

Craig
 

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

Excel 2003 - VBA - Kill Clipboard Message 1
Excel 2003 Clipboard Question 6
Closing a window after transferring data 2
Cannot copy worksheet to another file 2
How to copy/paste without using clipboard? 11
Cannot empty the clipboard 1
Clear Clipboard after Copy 2
Macro stops with "Large Amount of Data" Message 3

Top