Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

excel PasteSpecial mute clipboard warning

Posted on 2014-03-05
2
Medium Priority
?
308 Views
Last Modified: 2014-03-05
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
0
Comment
Question by:COACHMAN99
2 Comments
 
LVL 8

Accepted Solution

by:
5teveo earned 2000 total points
ID: 39907352
try

Application.DisplayAlerts = False
0
 
LVL 7

Author Closing Comment

by:COACHMAN99
ID: 39907390
excellent thanks.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question