Range.RemoveDuplicates Method (Excel)
Removes duplicate values from a range of values.
Version Information
Version Added: Excel 2007
Syntax
expression .RemoveDuplicates(Columns, Header)
expression A variable that represents a Range object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Columns |
Optional |
Variant |
Array of indexes of the columns that contain the duplicate information. If nothing is passed then it assumes all columns contain duplicate information. |
Header |
Optional |
XlYesNoGuess |
Specifies whether the first row contains header information. xlNo is the default value; specify xlGuess if you want Excel to attempt to determine the header. |
Example
The following code sample removes duplicates with all columns from a range.
ActiveSheet.Range("A1:C100").RemoveDuplicates
The following code sample removes duplicates with the first 2 columns
ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes