Copy Alert Displays in macro

[Malcolm1978]

Hi,

I have written a macro to combine 400 workbooks into one, which I do by copying all the worksheets into one file, when I close the workbook from which I have copied the file i get the "Large amount of information on the clipboard, do you want to keep this here" message. Is there any way I can write into the macro for this to be no?

I am aware of the code "Application.DisplayAlerts = False", however does this remove the data from the clipboard, as I am hoping to run this report overnight.

Many Thanks

 

[VoG]

Try

Application.CutCopyMode=False