Expand Minimize
1 out of 5 rated this helpful - Rate this topic

Range.RemoveDuplicates Method (Excel)

Published: July 16, 2012

Removes duplicate values from a range of values.

Version Added: Excel 2007

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.