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.