Slicer selection via Cell Value VBA

[deletedalien]

Hi guys:

Is there a way to make the slicer selection select all the values as FALSE except the CELL value

In other words:



ActiveWorkbook.SlicerCaches("Slicer_Camp").VisibleSlicerItemsList = Array("[Range1].[Campaña].&[CELL VALUE HERE]")


Also is there a way to set this for various slicers in different sheets? (i different data but same categories, that's why have several slicers)


Thanx

 

[deletedalien]

Bump