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

Version Information
Version Added: Excel

Name Value Description
xlFilterCopy 2 Copy filtered data to new location.
xlFilterInPlace 1 Leave data in place.