Range.RemoveDuplicates Method

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  ActiveSheet.Range("A1:C100").RemoveDuplicates

The following code sample removes duplicates with the first 2 columns

Visual Basic for Applications 
  ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes

See Also