Filter (7.4)

Filter a specified range.

Overloads

Overload Name Description
Between Select the items that lie between two values (inclusive) from the filter of the specified column.
BottomX Select the bottom X items from the filter of the specified column, where X is a specified number value.
BottomXPercent Select the bottom X percent items from the filter of the specified column, where X is a specified percent value.
Clear Clear all selections from all filters on the sheet.
Equals Select one specific value from the filter of the specified column.
FiltersOff Turn off filtering for the specified range.
FiltersOn Turn on filtering for the specified range. Functions as a toggle if filters are already on.
GreaterThan Select the items that are greater than the specified value from the filter of the specified column.
InList Select a list of values from the filter of the specified column.
LessThan Select the items that are less than the specified value from the filter of the specified column.
TopX Select the top X items from the filter of the specified column, where X is a specified number value.
TopXPercent Select the top X percent items from the filter of the specified column, where X is a specified percent value.

Between

Select the items that lie between two values (inclusive) from the filter of the specified column.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
LowValue The lower value to use in the between range.
HighValue The higher value to use in the between range.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

BottomX

Select the bottom X items from the filter of the specified column, where X is a specified number value.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
ValueOfX The value to use in Top and Bottom filters.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

BottomXPercent

Select the bottom X percent items from the filter of the specified column, where X is a specified percent value.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
ValueOfX The value to use in Top and Bottom filters.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

Clear

Clear all selections from all filters on the sheet.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

Equals

Select one specific value from the filter of the specified column.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
Value The value to select.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

FiltersOff

Turn off filtering for the specified range.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

FiltersOn

Turn on filtering for the specified range. Functions as a toggle if filters are already on.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

GreaterThan

Select the items that are greater than the specified value from the filter of the specified column.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
Value The value to select.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

InList

Select a list of values from the filter of the specified column.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
List The list of values to select in the specified column.
Delimiter The delimiter to use to parse the list of values. Comma, ",", is the default.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

LessThan

Select the items that are less than the specified value from the filter of the specified column.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
Value The value to select.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

TopX

Select the top X items from the filter of the specified column, where X is a specified number value.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
ValueOfX The value to use in Top and Bottom filters.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE

TopXPercent

Select the top X percent items from the filter of the specified column, where X is a specified percent value.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value: <blank>SheetNameSheetNumberAllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ColumnNumber The column number of the filter.
ValueOfX The value to use in Top and Bottom filters.
ClearFirst Whether to clear other selections from the filter before applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE
ShowDropdown Wheter the filter's dropdown should be displayed after applying the selection.
Specify one of the following values or an arbitrary value: <blank>FALSETRUE