Macro stops with "Large Amount of Data" Message

[dhstein]

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.

 

[Pete_UK]

You might like to add this to your macro before closing the workbook:

Application.DisplayAlerts = False

This will suppress the error message. Then turn it back on again with
this:

Application.DisplayAlerts = True

Hope this helps.

Pete

 

[FSt1]

hi
add this to the begining of your code...
Application.DisplayAlerts = false

this will turn off all of excel's built in error messages.

but...".big word"....be sure to turn them back on at the end of your code...
very unwise not to..........
Application.DisplayAlerts = TRUE

regards
FSt1

 

[dhstein]

Thanks for the information - it worked great

hi
add this to the begining of your code...
Application.DisplayAlerts = false

this will turn off all of excel's built in error messages.

but...".big word"....be sure to turn them back on at the end of your code...
very unwise not to..........
Application.DisplayAlerts = TRUE

regards
FSt1