Changing Pivot Range Programatically

  • Thread starter Thread starter Reney Langlois
  • Start date Start date
R

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
 
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

Pivot table code question 2
Pivot Tables - Multiple Ranges 9
How I can set dynamic pivot table ONLY when I have enough data point 1
selecting cells to produce a pivot table 4
macro creating new pivot table 2
VBA Pivot Table Error 1
Pivot table multiple filters 2
Macro to update pivot table data range 3

Back
Top