Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I'm just looking at pivot table stuff via VBA for the first time and am having some hassles: ..PivotItems(x).Visible = True is returning a 'run time error 1004 app/object defined error' for PivotItems in a given collection (when the property is initially manually set to False prior to running), whereas the same property set to false via script, on the same item (after manually setting to True) works fine. I can't work out what is going wrong... I'm using XL2000. Any ideas?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange Icon - Working with Pivot tables | Excel Discussion (Misc queries) | |||
Auto Refresh of Pivot Tables not working | Excel Worksheet Functions | |||
Working with Pivot tables with % change | Excel Worksheet Functions | |||
How do I disable "Get Pivot Data" when working from pivot tables? | Excel Worksheet Functions | |||
Working with Pivot Tables | Excel Discussion (Misc queries) |