Skip filter when not found

[ahuang3433]

Hi,

Is there a way to make this pivot skip a the filter criteria if not found?

ActiveSheet.PivotTables("PivotTable2").PivotFields("Item Availability"). _
        CurrentPage = "(All)"
    With ActiveSheet.PivotTables("PivotTable2").PivotFields("Item Availability")
        .PivotItems("ETA On Time & Qty Ordered Less than Demand").Visible = False
        .PivotItems("In Stock").Visible = False
        .PivotItems("No Gating PO").Visible = False
        .PivotItems("ETA Late").Visible = False
        .PivotItems("ETA On Time").Visible = False
        .PivotItems("Partial qty in INV. Balance No Gating PO").Visible = False
    End With

 

[Jeffrey Mahoney]

Add this code to skip errors. It needs to be turned off as soon as possible as to not bypass other real errors that could foul things up.

On error resume next 'This will bypass the error and go to the next line of code
On error goto 0 'This will remove catching the error (That is a zero at the end)

 

[ahuang3433]

Add this code to skip errors. It needs to be turned off as soon as possible as to not bypass other real errors that could foul things up.

On error resume next 'This will bypass the error and go to the next line of code
On error goto 0 'This will remove catching the error (That is a zero at the end)

Hi Jeffery - I'm not sure I am following you on this. Can you provide an example?

 

[Jeffrey Mahoney]

The more I think about it and because the pivot command is one unit, that won't work. You would have to go check your original table for each of those fields.

Why would your underlying data set for the pivot table change the fields?

 

[ahuang3433]

The more I think about it and because the pivot command is one unit, that won't work. You would have to go check your original table for each of those fields.

Why would your underlying data set for the pivot table change the fields?

I have it that way for presentation purposes. It's to isolate data that is not needed for review.

 

[Jeffrey Mahoney]

Are you deleting the columns of data in your dataset or hiding them?