Changing Pivot Range Programatically

[Reney Langlois]

Hi,
I'd like to change the range of cells that a pivot table
is referring to in code. Right now, when I record a macro
to do this, the resulting code utilizes the pivot wizard
but I've got to believe that there's a more direct way to
do this.

Thanks much,

Reney

 

[Tim Zych]

Use SourceData

PivotTableObj.SourceData = "NewlyResizedRangeName"