Nick,

Try setting the DisplayAlerts property to False. E.g.,

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nick" wrote in message
...
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.