Changing Pivot Range Programatically
 

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

Changing Pivot Range Programatically
 

Use SourceData

PivotTableObj.SourceData = "NewlyResizedRangeName"


"Reney Langlois" wrote in message
...
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