SlicerItem Members (Excel)

Represents an item in a slicer.

Properties

Name	Description
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
Caption	Returns the label text for the slicer item. Read-only.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
HasData	Returns whether the slicer item contains data that matches the current manual filter state. Read-only.
Name	Returns the name of the slicer item. Read-only.
Parent	Returns the parent SlicerCache object for the slicer item. Read-only.
Selected	Returns or sets whether the slicer item is selected. Read/write.
SourceName	Returns the source name of the slicer item. Read-only.
SourceNameStandard	Returns a String that represents the PivotTable items' source name in standard English (United States) format settings. Read-only.
Value	Returns the value of the slicer item. Read-only.