View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Flanagan[_2_] Bob Flanagan[_2_] is offline
external usenet poster
 
Posts: 81
Default Macro stops with "Large Amount of Data" Message

Before closing the file, execute the following statement:

Application.CutCopyMode = False

If the problem still continues, which it may, copy a single cell. This will
make the contents of the clipboard very small and thus eliminate the
message.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"dhstein" wrote in message
...
I have macro that copies some data from a workbook and then tries to close
it. I want it to run without stopping, but I get the message that there
is a
large amount of data in the clipboard - and I need to click "OK". Is
there a
way to suppress that message so the macro will complete? Thanks.