Pivot Table Filter Macro Error

[kibbles]

Good Evening All,
In my spreadsheet, I have variable data; however, I have a specific set of attributes that I'd want to be filtered upon if/when they do appear in the data run for that week. If they do not appear, I'd like the Pivot Table filter to skip over it and continue to the next.
Unfortunately, I keep getting debugging errors when I try to run my macro. Can anyone help?

I.E.
If "1G1N13S2" isn't in the variable [raw] data, it'd carry me straight to the VBA to debug instead of skipping over it (whether false or true) to continue on to the subsequent ID#.

Please Login or Register  to view this content.

Any help, I'd GREATLY appreciate.

[kibbles]

. .

[kibbles]

Still no ideas?

[kibbles]

So, I've gotten an answer as to how to fix this.

On Error Resume Next
With ActiveSheet.PivotTables("PivotTable1").PivotFields("ACTIVITY_ID")
.PivotItems("1G1N13S2").Visible = False
.PivotItems("1G1N2SAN").Visible = False
.PivotItems("1G1N5ACC").Visible = False
.PivotItems("1G1N5SCI").Visible = False
.PivotItems("1G1N5SDV").Visible = False
.PivotItems("E6T66ZJA").Visible = True
End With
On Error Goto 0

[kibbles]

double-post

[MarvinP]

Hi kibbles,

I wrote code to filter pivot data last year. I found that as soon as I filtered out all possible data, I got VBA errors. My answer was to make all items.visible = true to start with and then turn off what I didn't want to show.

I like your answer to On Error Resume Next. I don't think I ever tried that approach. Hope it works for you and thanks for sharing your answer.