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
|