Expand Minimize

XlFilterAction Enumeration (Excel)

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

Version Added: Excel 2007

Name

Value

Description

xlFilterCopy

2

Copy filtered data to new location.

xlFilterInPlace

1

Leave data in place.

Show:
© 2015 Microsoft