TimelineState Properties (Excel)

GitHub-Mark-64px

Contribute to this content

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

Name

Description

Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

EndDate

Returns the end of the filtering date range (equals to TimelineState.StartDate Property (Excel) if range is a single day). Variant Read-only

FilterType

Returns the type of the date filter. XlPivotFilterType Enumeration (Excel) Read-only

FilterValue1

Returns the 1st value associated with the date filter (semantics vary by filter type). Variant Read-only

FilterValue2

Returns the 2nd value associated with the date filter (semantics vary by filter type). Variant Read-only

Parent

Returns an Object that represents the parent object of the specified TimelineState Object (Excel) object. Read-only.

SingleRangeFilterState

True when the filtering state is a contiguous date range; False otherwise. Boolean Read-only

StartDate

Returns the start of the filtering date range. Variant Read-only

Show: