I use below VBA code to control Manufacturer field of the "Dropdown" pivot table via drop down box. Based on the selection from drop down box pivot table manufacturer field should change. Code used tow ork perfectly but its giving me error since i changed the pivot table and highlights below row in yellow. Can you please advise
ActiveSheet.PivotTables("Dropdown").PivotFields("Manufacturer").ClearAllFilters
ActiveSheet.PivotTables("Dropdown").PivotFields("Manufacturer").ClearAllFilters
Code:
Sub Dropdown()
'
'Dropdown Macro
'
'
Sheets("POS Tracker").Select
Sheets("POS Tracker").Visible = True
Sheets("Source").Visible = True
Sheets("Source").Select
ActiveSheet.PivotTables("Dropdown").PivotFields("Manufacturer").ClearAllFilters
ActiveSheet.PivotTables("Dropdown").PivotFields("Manufacturer").CurrentPage = "(All)"
ActiveSheet.PivotTables("Dropdown").PivotFields("Manufactuer").CurrentPage = Range("C226").Text
Sheets("Source").Visible = False
End Sub