SlicerCaches object (Excel)

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

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")

Methods

• Add

Properties

• Application
• Count
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.