I have recored a macro and i trying to use in ather workbooks and it giving me errors RRS feed

  • Question

  • With ActiveSheet.PivotTables("PivotTable3").PivotFields("Comments")
            .PivotItems("dispute -ASN").Visible = True 
            .PivotItems("dispute -FR").Visible = True

    in the above code "().visible = sometime it will true and some time false"

    is there any solution for this scenario that if .visble = false

    Friday, February 22, 2019 7:53 PM