<div>
<div class="content wysiwyg-content">
Hi All,<br />
does anyone know how to mute the Excel PasteSpecial clipboard warning? (or should I use another copy function?<br />
<br />
I need to copy/paste from external workbooks and not get the 'large amount of data ..&quot; warning<br />
<br />
current syntax:<br />
DestWbk.Worksheets(&quot;Sheet2<wbr />&quot;).Range(&quot;<wbr />A1&quot;).Paste<wbr />Special xlPasteAll<br />
<br />
thanks
</div>
</div>


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

excel PasteSpecial mute clipboard warning

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.