Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to cycle through all visible labels in pivot table columns. I tried
to use this code: Set pt = Sheets("Table").PivotTables(1) For Each pf In pt.ColumnFields For Each pi In pf.PivotItems With pi.LabelRange.Interior .ColorIndex = 25 End With Next pi Next pf If all items are visible, it works fine, but hidden items cause error. I am trying to avoid using error handler. Anybody knows a better way? Thanks much - RADO |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combine column labels in pivot table | Excel Worksheet Functions | |||
repeat row labels in pivot table | Excel Worksheet Functions | |||
pivot table vicious cycle | Excel Discussion (Misc queries) | |||
Can pivot table column labels be filtered? | Excel Discussion (Misc queries) | |||
How can I repeat labels in a Pivot Table? | Excel Worksheet Functions |