Hi Bruce
After the paste line use
Application.CutCopyMode = False
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Bruce" wrote in message ...
When I do a paste special as below I get the following prompt;
'There is a large amount of information on the clipboard. Do you want to
paste this information later.
How can I auto answer No to this?
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False
Regards,
Bruce