Hello All...
I have:
Is there a way to refresh both charts on this one sheet, instead of having separate Chart Object Activation...like the recorder wants me to do?
Thanks for the help!
I have:
VBA Code:
Sheets("Spray Booth 1 PVT").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.PivotLayout.PivotTable.PivotCache.Refresh
ActiveSheet.ChartObjects("Chart 2").Activate
ActiveChart.PivotLayout.PivotTable.PivotCache.Refresh
Is there a way to refresh both charts on this one sheet, instead of having separate Chart Object Activation...like the recorder wants me to do?
Thanks for the help!