<< 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.