Prev: Selecting Multiple columns with multiple rows
Next: are there any VBA consultants left ? - will pay for help
From: RDiva on 9 Apr 2010 11:41
I have written code which updates several pivot table page fields using a
list. Is there a way to also update a pivot table field when it's used in a
pivot table as a column/row? I tried the code below, however, I get an error
stating that the 'Object doesn't support this property or method'. The only
other option I could think of was to create a second field in the data sheet
which would contain the same data then use this new field as a page field in
the pivot table but I would like to know if there is a better way to do this.

Sheets("Pivot Tables").Select

ActiveSheet.PivotTables("PivotTable2").PivotItems("Product
Line").CurrentPage = Sheets("Sales").Range("E3").Value
ActiveSheet.PivotTables("PivotTable2").PivotItems("Region").CurrentPage =
Sheets("Sales").Range("B3").Value

--
RDiva
 | 
Pages: 1
Prev: Selecting Multiple columns with multiple rows
Next: are there any VBA consultants left ? - will pay for help