Skip to main content

Range.RemoveDuplicates method

Table of contents
  1. Syntax
  2. Parameters
  3. Example

Removes duplicate values from a range of values.


expression.RemoveDuplicates (Columns , Header)

expression A variable that represents a Range object.


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.


The following code sample removes duplicates with the first 2 columns.

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>