Filter Function

Returns a zero-based array containing subset of a string array based on a specified filter criteria.

Syntax

Filter(sourcearray, match [, include ] [, compare ] )

The Filter function syntax has these arguments:

Argument

Description

sourcearray

Required. One-dimensional array of strings to be searched.

match

Required. String to search for.

include

Optional. Boolean value indicating whether to return substrings that include or exclude match. If include is True, Filter returns the subset of the array that contains match as a substring. If include is False, Filter returns the subset of the array that does not contain match as a substring.

compare

Optional. Numeric value indicating the kind of string comparison to use. See Settings section for values.

Settings

The compare argument can have the following values:

Constant

Value

Description

vbUseCompareOption

–1

Performs a comparison using the setting of the Option Compare statement.