XlFilterAction enumeration (Excel)

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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.