Thread: Date in cell to update upon Pivot Table refresh
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
chris46521[_34_] chris46521[_34_] is offline
external usenet poster
  
Posts: 1
Default Date in cell to update upon Pivot Table refresh

Thanks for your response! Do you know what code I might use to make that
work? I am not that familiar with VBA. Thanks again.

Excelenator Wrote:
you could use the "Workbook_SheetPivotTableUpdate" or the
"Worksheet_PivotTableUpdate" event to place the current date in a
particular cell each time the pivot table updates.


--
chris46521
------------------------------------------------------------------------
chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909
View this thread: http://www.excelforum.com/showthread...hreadid=572248

Reply With QuoteReply With Quote