Expand Minimize
2 out of 9 rated this helpful - Rate this topic

Range.AdvancedFilter Method (Excel)

Filters or copies data from a list based on a criteria range. If the initial selection is a single cell, that cell's current region is used.

expression .AdvancedFilter(Action, CriteriaRange, CopyToRange, Unique)

expression A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

Action

Required

XlFilterAction

One of the constants of XlFilterAction specifying whether to make a copy or filter the list in place.

CriteriaRange

Optional

Variant

The criteria range. If this argument is omitted, there are no criteria.

CopyToRange

Optional

Variant

The destination range for the copied rows if Action is xlFilterCopy. Otherwise, this argument is ignored.

Unique

Optional

Variant

True to filter unique records only. False to filter all records that meet the criteria. The default value is False.

Return Value

Variant

This example filters a database (named "Database") based on a criteria range named "Criteria."

Range("Database").AdvancedFilter _ 
 Action:=xlFilterInPlace, _ 
 CriteriaRange:=Range("Criteria")

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.