- Mar 16, 2011
With Sheet6 .PivotTables("PivotTable2"). _ PivotFields("Name").CurrentPage = "Text" End With
This code is not working. If I change "Sheet6" to "ActiveSheet" and activate Sheet6, it works just fine.
I don't want to have to activate all the sheets that I'm going to be working with. Is there any way to fix this code?