SlicerCaches Object (Excel)

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

Version Information

Version Added: Excel 2010

Remarks

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.

Example

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

ActiveWorkbook.SlicerCaches("Slicer_Country")

See Also

Concepts

Excel Object Model Reference

SlicerCaches Object Members