<div>
No - you have to clear the area before you refresh, I think (assuming DisplayAlerts doesn't work)
</div>


<div>
Your right, it does!!<br />
<br />
Thanks<br />
Seamus
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a macro which runs a report where the pivots refresh. On the refresh i am often promted <br />
<br />
&quot;Do you want to replace the contents of the destination cells in Screen&quot;<br />
YES/NO<br />
<br />
Can i put a line of code after pivot refresh to surpress this message, always saying YES.<br />
<br />
Thanks<br />
Seamus
</div>
</div>


Hi,

I have a macro which runs a report where the pivots refresh. On the refresh i am often promted 

"Do you want to replace the contents of the destination cells in Screen"
YES/NO

Can i put a line of code after pivot refresh to surpress this message, always saying YES.

Thanks
Seamus

No - you have to clear the area before you refresh, I think (assuming DisplayAlerts doesn&#39;t work)

Say yes to prompt

Hi,

I have a macro which runs a report where the pivots refresh. On the refresh i am often promted 

&quot;Do you want to replace the contents of the destination cells in Screen&quot;
YES/NO

Can i put a line of code after pivot refresh to surpress this message, always saying YES.

Thanks
Seamus

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.