Changing Pivot Table Range
Thanks,
However, it uses the PivotTableWizard. Not the result
that I am after.
Have fun,
Rod.
-----Original Message-----
Hi
as a starting point: Record I macro while you're doing
this manually.
--
Regards
Frank Kabel
Frankfurt, Germany
Rod wrote:
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.
.
|