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. |
Excel Object Model Enumerations
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. |