Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I stumbled over a similar problem recently while trying to save specific pivot table layouts. I solved it by using a case select and making the pagefield temporarily a rowfield. .... Dim pt as PivotTable Dim objPF As PivotField Dim pfItem As PivotItem .... For Each objPF In pt.VisibleFields Select Case objPF.Orientation Case xlRowField For Each pfItem In objPF.PivotItems If pfItem.Visible = True Then ... End If Next pfItem Case xlColumnField For Each pfItem In objPF.PivotItems If pfItem.Visible = True Then ... End If Next pfItem Case xlPageField objPF.Orientation = xlRowField For Each pfItem In objPF.PivotItems ' Debug.Print pfItem.Parent.Name, pfItem.Name, pfItem.Visible If pfItem.Visible = True Then .... End If Next pfItem objPF.Orientation = xlPageField Case xlDataField Case xlHidden End Select Next objPF |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? | Charts and Charting in Excel | |||
Missing PivotItems | Excel Programming | |||
PivotItems Bug?! | Excel Programming | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming |