macros

  • Thread starter Sanford Lefkowitz
  • 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
 
M

Mike H

Hi,

Application.displayalerts=false

your code

Application.displayalerts=true

Mike
 
G

Gord Dibben

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

Application.CutCopyMode = False


Gord Dibben MS Excel MVP
 

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

Copy and Paste question 1
Macro stops with "Large Amount of Data" Message 3
errot in macro 1
Override prompt for Office Clipboard 3
Excel 2003 - VBA - Kill Clipboard Message 1
Copying parts of a sheet with macro 7
Get rid of Information message 3
excel macro-copy formula to entire column? 2

Top