PivotItems Visible = False Error When Item Does not Exist

**Nunzio** · 10-16-2013, 09:50 AM

The problem I am having is that I what to exclude a pivot field item, but sometimes if the item does not exist I get an error so I want visible = false only IF the items exists.

Thanks Nunzio

Please Login or Register  to view this content.

**Izandol** · 10-16-2013, 10:01 AM

Probably the easiest way:

Please Login or Register  to view this content.

**Nunzio** · 10-16-2013, 10:22 AM

Thank you for your help!! Nunzio

PivotItems Visible = False Error When Item Does not Exist

LinkBack

Thread Tools

Rate This Thread

Display

PivotItems Visible = False Error When Item Does not Exist

Re: PivotItems Visible = False Error When Item Does not Exist

Re: PivotItems Visible = False Error When Item Does not Exist

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Error 1004 with PivotItems.Visible

Error on PivotItems.Visible = False with dates

Stopping VBA Search from showing error if searched item does not exist

Error Message - .PivotItems("(blank)").Visible = True

Bookmarks

Bookmarks

Posting Permissions