View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
rhody[_5_] rhody[_5_] is offline
external usenet poster
 
Posts: 1
Default How to avoid "large data on clipboard" message?

Use:

Application.DisplayAlerts = False

This will shut off all messages. Turn it back on after your cut/paste
if you want to restore messages. I generally leave it off until the end
of the module.

Mike



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/