I am still having issues getting a working drop down to change pivot filters! I have a spreadsheet with a drop down that should set the filter in pivot table 3 to be the value of cell V6 I get Runtime Error 5.
Any help appreciated!!![]()
ActiveSheet.PivotTables("PivotTable3").PivotFields("IP1").CurrentPage = _ ActiveSheet.Range("V6").Value
Bookmarks