Probs With Message Boxes After Recording Macro

[Dazzawm]

I have recorded quite a complex macro and when I run it all is good but it comes up with a couple of message boxes. How do I get the macro to automatically say yes?

The first box says there is a large amount of data on your clipboard etc etc then there is a box that says the data is not the same size do you want to paste it anyway. Thanks.

 

[Nogslaw]

Try this line at the beginning of your code:

application.displayalerts = false

and

application.displayalerts = true

at the end of your code.

 

[Dazzawm]

So although this says not to display alerts will it say yes to them?

 

[Nogslaw]

Yep. This tells Excel to not even display them ... just execute the commands (copy, paste, etc.)

 

[Dazzawm]

Thankyou Nogslaw.