I have a macro that does certain functions on startup of my worksheet, during
startup it collects info from a main file then pastes that info into the
worksheet. I was wondering if there is a line of code that selects yes when
the message box comes up and asks if you would like to 'replace the contents
of the desination cells'. Also is there a line of code that will select no
when it asks if you would like to save the large amount of information on the
clipboard.