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.