| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Pivot-Table Visible Items
With ActiveSheet.PivotTables("AssetPT").PivotFields("Co st ctr")
.PivotItems("12476").Visible = True .PivotItems(DataArray(X, 1)).Visible = True end with Why would the line with "12476" work and the line immediately below, where DataARray(x,1) equals "12476" give me this error: Error (1004) Unable to get teh pivotItems property of the pivotfield class????? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set Pivot-Table Visible Items
Manually or programmatically set the field to Manual sort, to prevent
that error: With ActiveSheet.PivotTables("AssetPT").PivotFields("Co st ctr") .AutoSort xlManual, .SourceName Mike H. wrote: With ActiveSheet.PivotTables("AssetPT").PivotFields("Co st ctr") .PivotItems("12476").Visible = True .PivotItems(DataArray(X, 1)).Visible = True end with Why would the line with "12476" work and the line immediately below, where DataARray(x,1) equals "12476" give me this error: Error (1004) Unable to get teh pivotItems property of the pivotfield class????? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Pivot Item Visible - Why so difficult | Excel Programming | |||
| Pivot Table Programming (Selecting Pivot Items) | Excel Programming | |||
| Pivot Table Programing Help (Selecting Pivot Items) | Excel Programming | |||
| Unable to access visible property of Pivot Items class | Excel Programming | |||
| Unable to access visible property of Pivot Items class | Excel Programming | |||
Linear Mode
