Pivot Table and Last Row

A

Aaron

I am trying to refresh a Pivot table to the last row in a Macro. Any Ideas

Here is what I have so far

Sub Refresh(

Sheets("PivotCharts").Selec
ActiveSheet.PivotTables("PivotTable11").RefreshTabl

End Su

Thanks in advance
Aaron
 
D

Debra Dalgleish

Are you trying to refresh the pivottable so it includes new data that
you've added to the source table? You can base the pivot table on a
dynamic range, which will automatically expand to include new items.
There are instructions here:

http://www.contextures.com/xlPivot01.html

Then, when you refresh the pivottable, the new data will be included.
 
Top