dimanche 10 mai 2015

Error 1004: Application-defined or Object-defined Error

Hello I am kind of new in VB and I am trying to control different pivot tables with a combobox, but when I try to do so I receieve the same error that says: "Error 1004: Application-defined or Object-defined Error". This is the code that I am using. Could someone help me to solve this issue?

Sub SwitchMarkets()

ActiveSheet.PivotTables("PivotTable1").PivotFields("Market").ClearAllFilters
ActiveSheet.PivotTables("PivotTable1").PivotFields("Market").CurrentPage = _
    Worksheets("Using Combo Box Controls").Range(“O5”).Value
ActiveSheet.PivotTables("PivotTable2").PivotFields("Market").ClearAllFilters
ActiveSheet.PivotTables("PivotTable2").PivotFields("Market").CurrentPage = _
    Worksheets("Using Combo Box Controls").Range(“O5”).Value

End Sub

Thanks!!

Aucun commentaire:

Enregistrer un commentaire