Unless you copy the range to a new worksheet it leaves the current worksheet with filtering on which can cause issues with end users trying to continue to manually manipulate the data. I prefer to use "RemoveDuplicates"
|Action||Required||XlFilterAction||One of the constants of XlFilterAction specifying whether to make a copy or filter the list in place.|
|CriteriaRange||Optional||Variant||The criteria range. If this argument is omitted, there are no criteria.|
|CopyToRange||Optional||Variant||The destination range for the copied rows if Action is xlFilterCopy. Otherwise, this argument is ignored.|
|Unique||Optional||Variant||True to filter unique records only. False to filter all records that meet the criteria. The default value is False.|
Specifies whether data is to be copied or left in place during a filter operation.
|xlFilterCopy||2||Copy filtered data to new location.|
|xlFilterInPlace||1||Leave data in place.|
NOTE: You must have a "Header" or the filter won't look at the first cell and compare w/ the rest.