Auto Filter Properties

Name Returns Description

Filter Boolean Set/Get whether a given worksheet is in the AutoFilter

Mode filter mode

Filters

Filters

Read-only. Returns the collection of filters associated with the range that was auto-filtered (for example, non-blank rows)

Range

Range

Read-only. Returns the group of cells that have an AutoFilter applied to them

Sort

Sort

Controls the attributes and specifications of a sort with the AutoFilter object

0 0

Post a comment