Thank you!

Excelenator Wrote:
You could use something like this if you want the current date time in
cell A1 when the pivot table updates. Remember to format cell A1 with
the date time format you want.


Code:
--------------------
Sub Worksheet_PivotTableUpdate()
Range(A1).Value = NOW()
End Sub
--------------------



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