SlicerCaches Object (Excel)

Represents the collection of slicer caches associated with the specified workbook.

Version Added: Excel 2010

Use the Item property of the SlicerCaches collection to return a SlicerCache object associated with the specified Workbook object. A SlicerCache object can be retrieved by using either the value of the Index property or the Name property of the specified object.

The following code example retrieves the SlicerCache object that represents the slicer cache associated with the Country slicer.

ActiveWorkbook.SlicerCaches("Slicer_Country")
Show:
© 2014 Microsoft