excel PasteSpecial mute clipboard warning

COACHMAN99
COACHMAN99 used Ask the Experts™
on
Hi All,
does anyone know how to mute the Excel PasteSpecial clipboard warning? (or should I use another copy function?

I need to copy/paste from external workbooks and not get the 'large amount of data .." warning

current syntax:
DestWbk.Worksheets("Sheet2").Range("A1").PasteSpecial xlPasteAll

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012
Commented:
try

Application.DisplayAlerts = False

Author

Commented:
excellent thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial