TimelineState object (Excel)

The timeline-specific state of a SlicerCache object.

Remarks

Supported contiguous ranges can be set through the SetFilterDateRange method. When the timeline has such a contiguous filter state, the state can be retrieved from the two properties StartDate and EndDate.

Any state that the filter may have, including non-contiguous states, can be retrieved through the three properties FilterType, FilterValue1, and FilterValue2.

Methods

• SetFilterDateRange

Properties

• Application
• Creator
• EndDate
• FilterType
• FilterValue1
• FilterValue2
• Parent
• SingleRangeFilterState
• StartDate

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.