Hi fmistry

You can copy without using the clipboard (one line of code)
Sheets("Sheet1").Range("A1:Z1000").Copy Sheets("Sheet2").Range("A1")

Or use this to clear the clipboard after the paste line in your code
Application.CutCopyMode = False


--
Regards Ron de Bruin
http://www.rondebruin.nl



"fmistry" wrote in message oups.com...
I am using a macro to transfer a large data from one worksheet to
another, and I would like this is to occur automatically at a given
frequency (once an hour, etc). I get the information message that
"There is a large amount of information on the clipboard. Do you want
to save it? etc" and the macro stops there, waiting for a reply. How
do I get the macro to either suppress this message or answer the
message with a "no"? Also, how do I set up a loop to run this macro at
regular intervals? Thanks for your help.