| 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????? |
| 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 | |||
Threaded Mode
