Rob,
Thanks. I should have explained more throroughly. I do
want to keep the info in the clipboard. I am
consolidating information from a number of workbooks into
a single workbook. I do not want the user to have to
respond "yes" to every prompt. Based on your suggestion,
I tried Application.CutCopyMode = xlCopy but the macro
failed on the paste... any suggestion?
Thanks, regards,
Gary
-----Original Message-----
"gary" wrote in message
...
Does anyone have a snipit of code that will respond to
the
clipboard prompt...
"There is a large amount of information on the
clipboard.
Do you want to ..."

Hi Gary,

Application.CutCopyMode = False

will prevent this message from being displayed. Just make
sure you're done
with whatever is on the clipboard before you use it,
because it will clear
the clipboard.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *



.