dynamic tables with VBA jump error and follow

0

I have a dynamic table where there is a selection filter and I want to choose only certain ones, I know how to choose them but when there is not one, I get an error and it stops. Is it possible to make a Loop that travels all and selects only those that you find? With this code, I remove from 1 to 15, but if you do not find one of them, it stops and does not follow.

Thanks and best regards

Sub tablaDinamica_Tiempos()

ActiveSheet.PivotTables("tabla_7").PivotFields("Duration"). _
                ClearAllFilters

        ActiveSheet.PivotTables("tabla_7").PivotFields("Duration"). _
            CurrentPage = "(ALL)"

        With ActiveSheet.PivotTables("tabla_7").PivotFields("Duration")

           .PivotItems("0").Visible = False
           .PivotItems("1").Visible = False
           .PivotItems("2").Visible = False
           .PivotItems("3").Visible = False
           .PivotItems("4").Visible = False
           .PivotItems("5").Visible = False
           .PivotItems("6").Visible = False
           .PivotItems("7").Visible = False
           .PivotItems("8").Visible = False
           .PivotItems("9").Visible = False
           .PivotItems("10").Visible = False
           .PivotItems("11").Visible = False
           .PivotItems("12").Visible = False
           .PivotItems("13").Visible = False
           .PivotItems("14").Visible = False
           .PivotItems("15").Visible = False


     End With

End Sub

    
asked by luis b 15.05.2018 в 00:01
source

0 answers