PivotTable in Macro

[Herbivor]

I would like to set up a macro to refresh a PivotTable.
The range of the PivotTable may change on each run of the
macro (number of rows will vary in data set). I tried by
placing my cursor inside of the data set during the macro
record, but, however I implement, the macro always uses a
non variable reference. How can this be done?

 

[Debra Dalgleish]

You could base the pivot table on a dynamic data source, and it would
resize automatically. There are instructions here:

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