How to Set datarange for pivot table?

M

M Carman

What is the correct way to update the data source for a pivot table? All I've
come up with is the following, but the new data range does not apply when the
code runs. Is there a way to update the range directly wthout using the
PivotTableWizard method? Is there a way to use "A1" referencing instead of
"R1C1"?

dim X as integer
Sheets("ws1").PivotTableWizard SourceType:=xlDatabase, _
SourceData:="ws2!R1C1:R" & X & "C15"
 

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 Macro with dynamic source data 1
Pivot table code question 2
Macro to update pivot table data range 3
Playing back a Pivot Table macros 2
Batch Pivot Table update 0
syntax in VBA to create a pivot table 2
Dealing with a Pivot Table (when I don't want to) 0
Creating a Pivot Table via Macro - Errors on Recorded Code 3

Top