turn off pastespecial warnings
 

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