Can you help?

I am using a macro to update a pivot tbae but when I run the macro a
dialogue box appears saying:

Do you want to replace the destination cells in report3?

The answer to the question is always Yes but how do I get the macro to answe
yes and not to display the fialogue box to the user?

Many thanks,

Nick.