AdvancedFilter method

Carries out an Excel Advanced Filter, with this TableData object as the destination.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
✓

Parameters

Name	Type	Description
Source	Range	Source data for the advanced filter.
Criteria	Range (optional)	Advanced filter criteria range if required.
Unique	Boolean (optional)	If True, returns only unique values.
Columns	Integer (optional)	If specified, the Advanced Filter target range is the first Columns columns of this TableData object.

The TableData object can be a table if required. It is cleared before carrying out the advanced filter, and resized afterwards to the number of rows returned.