TimelineState Object (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

The timeline-specific state of a SlicerCache Object (Excel) object.

Supported contiguous ranges can be set through the TimelineState.SetFilterDateRange Method (Excel) method. When the Timeline has such a contiguous filter state, the state can be retrieved from the two properties TimelineState.StartDate Property (Excel) and TimelineState.EndDate Property (Excel). Any state that the filter may have, including non-contiguous states, can be retrieved through the three properties: TimelineState.FilterType Property (Excel), TimelineState.FilterValue1 Property (Excel), and TimelineState.FilterValue2 Property (Excel).

© 2015 Microsoft