Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warnings | Excel Discussion (Misc queries) | |||
turn off pastespecial warnings | Excel Programming | |||
Upcoming expiry date warnings that turn cell contents red | Excel Discussion (Misc queries) | |||
How do I turn off macro warnings? | Excel Programming | |||
Turn off warnings in Macro | Excel Worksheet Functions |