AutoFilter

(1.9) Represents the AutoFilter object and turns column values into specific filters based on the cell contents.

applyApplies the AutoFilter if column index and filter criteria are specified. Method
contextReturns the request context associated with the object. Property
clearCriteriaClears the filter criteria of the AutoFilter. Method
criteriaReturns an array that holds all the filter criteria in the autofiltered range. Property
enabledSpecifies if the AutoFilter is enabled. Property
getRangeReturns the Range object that represents the range to which the AutoFilter applies. Method
getRangeOrNullObjectIf there is no Range object, then this method returns an object with its isNullObject property set to true. Method
isDataFilteredSpecifies if the AutoFilter has filter criteria. Property
loadQueues up a command to load the specified properties of the object. Method
reapplyApplies the specified Autofilter object currently on the range. Method
removeRemoves the AutoFilter for the range. Method

apply
Applies the AutoFilter if column index and filter criteria are specified. Method
context
Returns the request context associated with the object. Property
clearCriteria
Clears the filter criteria of the AutoFilter. Method
criteria
Returns an array that holds all the filter criteria in the autofiltered range. Property
enabled
Specifies if the AutoFilter is enabled. Property
getRange
Returns the Range object that represents the range to which the AutoFilter applies. Method
getRangeOrNullObject
If there is no Range object, then this method returns an object with its isNullObject property set to true. Method
isDataFiltered
Specifies if the AutoFilter has filter criteria. Property
load
Queues up a command to load the specified properties of the object. Method
reapply
Applies the specified Autofilter object currently on the range. Method
remove
Removes the AutoFilter for the range. Method

REMARKS
* Added in 1.9
* For the Microsoft documentation refer to docs.microsoft.com

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top