Hi,

I have a pivot table based on a worksheet range. I would
like to be able to change the source range thru VBA. I
know I can use the PivotTableWizard method, but I would
prefer to manipulate the appropriate objects and
properties myself. All the help topics I can find only
use the PivotTableWizard. Is there some other way that I
can use to enlarge or shrink the range on a worksheet that
the pivot table gets it's data from ?

Any assistance appreciated.

RodT.