Changing Pivot Table Range

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

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.
 
Hi
as a starting point: Record I macro while you're doing this manually.
 
Thanks,

However, it uses the PivotTableWizard. Not the result
that I am after.

Have fun,

Rod.
 
The best way around this that I have found is to set up
your Pivot table range as a named range. Then I use code
to adjust the address of the named range and refresh the
pivot table.
Diane
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing PivotTable Source programmatically 1
Macro to Refresh child pivot table 4
How to update datasources of a pivot table ? 1
Pivot Table from external CSV file using VBA 2
Dynamically refreshing Pivot Table Range. 3
Automating a Pivot Table 1
Macro to update pivot table data range 3
Pivot Refresh Error when calling Excel Macro from VB.NET program 0

Back
Top