macros

  • Thread starter Thread starter Sanford Lefkowitz
  • Start date Start date
S

Sanford Lefkowitz

I am running a macrom that includes a number of copies and pastes of large
amounts of data. I keep getting the message about there being a large amount
of data on the clipboard. Do I want to keep it. After clicking No the, macro
proceeds.
How do I either prevent this message from popping up? or automatically
answer it 'No'

TIA
Sanford
 
After the copy and paste add this line to clear the clipboard.

Application.CutCopyMode = False


Gord Dibben MS Excel MVP
 
Back
Top