turn off pastespecial warnings
 

You could try :

Application.Displayalerts=FALSE
Selection.PasteSpecial Paste:=xlPasteAll,
Operation:=xlNone,SkipBlanks:=False, Transpose:=False



Corey....
"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