Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
The first line below works cleanly in my project, but I am having errors/issues with the next two lines. Globals.Sheet16.PivotTables("PivotTable2").PivotCa che.Refresh() Globals.Sheet16.PivotTables("PivotTable2").PivotFi elds("fy").Item(1).Visibl* e = True Globals.Sheet16.PivotTables("PivotTable2").PivotFi elds("fy").Item(2).Visibl* e = False Please advise as to what is needed to revise the code to get it to work as expected. Thanks, Kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table dynamic range code needed | Excel Programming | |||
Excel Pivot Table VB Code | Excel Discussion (Misc queries) | |||
Macro Revision needed | Excel Programming | |||
Get VSTO code to run on every launch of Excel | Excel Programming | |||
Pivot table help needed | Excel Programming |