XlFilterAction Enumeration

Specifies whether data is to be copied or left in place during a filter operation.

Version Information

Version Added: Excel 2007

Name

Value

Description

xlFilterCopy

2

Copy filtered data to new location.

xlFilterInPlace

1

Leave data in place.