Automatically Say Yes to Excel Questions and Continue Loop

[RG FL]

I'm working on automatically refreshing files with pivot tables with a macro. However, the macro execution stops temporarily when excel asks the following:

Do you want to replace the contents of the destination cells in "Sheet Name referenced here"?

How can I automatically say yes to these requests for information?

 

[Scott Huish]

See if this works for you, at the beginning of your code, put:

Application.DisplayAlerts = False

and before your code ends:

Application.DisplayAlerts = True

 

[RG FL]

It works, thanks!