Slicers Object (Excel)
Published: July 16, 2012
A collection of Slicer objects.
Use the Slicers property to return the Slicers collection. The following code example displays the number of slicers in the first slicer cache in the workbook.
Use Slicers(index), where index is the slicer index number or name, to return a single Slicer object from the slicers collection. The following code example changes the caption for the first slicer in the first slicer cache to "My Slicer".