View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marshall Marshall is offline
external usenet poster
 
Posts: 1
Default Working with Pivot Tables in VBA

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