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
 
Top