Range.RemoveDuplicates Method

Removes duplicate values from a range of values.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub RemoveDuplicates ( _
    Columns As Object, _
    Header As XlYesNoGuess _
)
'Usage
Dim instance As Range
Dim Columns As Object
Dim Header As XlYesNoGuess

instance.RemoveDuplicates(Columns, Header)

void RemoveDuplicates(
    Object Columns,
    XlYesNoGuess Header
)

Parameters

• Columns
  Type: System.Object

  Optional Object Array of indexes of the columns that contain the duplicate information. If nothing is passed then it assumes all columns contain duplicate information.

• Header
  Type: Microsoft.Office.Interop.Excel.XlYesNoGuess

  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.

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace