View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
nickysquawkes nickysquawkes is offline
external usenet poster
 
Posts: 1
Default Refresh Pivot Table: Do you want to replace the destination cells


I think you need to turn the display alerts off using the following:

Application.DisplayAlerts = False

Nick


--
nickysquawkes
------------------------------------------------------------------------
nickysquawkes's Profile: http://www.excelforum.com/member.php...o&userid=30630
View this thread: http://www.excelforum.com/showthread...hreadid=502834