AutoFilter (object)

<< Click to Display Table of Contents >>

AutoFilter (object)

Access paths:

Application à Workbooks à Item à Sheets à Item à AutoFilter

Application à Workbooks à ActiveSheet à AutoFilter

Application à ActiveWorkbook à ActiveSheet à AutoFilter

Application à ActiveSheet à AutoFilter

 1  Description

The AutoFilter object allows you to access the AutoFilter of a worksheet. In PlanMaker, such filters can be set with the ribbon command Data | Filter group | AutoFilter.

 2  Access to the object

Each worksheet (Sheet) has exactly one AutoFilter object. It can be accessed through Sheet.AutoFilter:

' Display the number of columns in the AutoFilter

MsgBox pm.ActiveSheet.AutoFilter.Filters.Count

 3  Properties, objects, collections and methods

Objects:

Application Application

Parent Sheet

 

Collections:

Filters Filters

Application (pointer to object)

Data type: Object

Returns the Application object.

Parent (pointer to object)

Data type: Object

Returns the parent object, i.e. an object of the type Sheet.

Filters (pointer to collection)

Data type: Object

Returns the Filters collection that allows you to access the individual columns in an AutoFilter.