Pivot Table Macro
I'm creating a pivot table in a macro and when it is done, I'm looking to
have the rows set to display detail=false. The rows contain employee names
and may change from one pivot table to the next. When I do this manually
with the recorder, I get the code:
ActiveSheet.PivotTables("PivotTable3").PivotFields ("Employee").PivotItems( _
"Chappie").ShowDetail = False
I thought I could enter wildcard * for Chappie, but that did not work. Is
there a way I can set all of these to false without reading the name one by
one?
--
Thanx, I do appreciate it.
|