Hi All,
How can I amend this code to change the slicer caption of a particular slicer on the active sheet
Im running this on the pivot table event on the sheet
If Worksheets("PivotSurvey").Range("AA2").Value = "State" Then
ActiveWorkbook.activesheet.SlicerCaches("Lead Trainer...