SlicerCache.PivotTables (Excel)

Returns a SlicerPivotTables collection that contains information about the PivotTables that the slicer cache is currently filtering.

The SlicerPivotTables collection returned by the PivotTables property will be empty if the slicer associated with the specified SlicerCache is not connected to any PivotTables.

Dim sptsPivotTables As SlicerPivotTables
Set sptsPivotTables = ActiveWorkbook.SlicerCaches(1).PivotTables