wish2excel
New Member
- Joined
- Aug 19, 2010
- Messages
- 20
Code:
ActiveSheet.PivotTables("PivotTable1").PivotFields("Agent Name").CurrentPage = MyName
ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage = dselect
Iam trying to update my pivot table with this code and i am getting an error "unable to set the currentpage property pf the pivotfield class"