Excel 2003 - VBA - Eliminate Clipboard Message

  • Thread starter Thread starter C Brandt
  • Start date Start date
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
 
Hit the Esc key. In VBA, insert the following line into your code:
Application.CutCopyMode = False
HTH Otto
 
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
 
Back
Top