Removes duplicate values from a range of values.
Syntax
expression.RemoveDuplicates (Columns , Header)
expression A variable that represents a Range object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Columns | Required | Variant | Array of indexes of the columns that contain the 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 the first 2 columns.
ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes