Saturday 15 November 2014

Refresh the Pivot Table on Button Click

Sub RefreshPivotTable()
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh

End Sub
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)