SlicerItems object (Excel)

Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.

Remarks

To access the SlicerItems collection that represents the items in a slicer based on data in the workbook or non-OLAP external data, use the SlicerItems property of the SlicerCache object that is associated with the slicer.

To access the SlicerItems collection that represents the items in a slicer based on an OLAP data connection, use the SlicerItems property of the SlicerCacheLevel object that represents a level of the hierarchy.

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.