NamedRange.RemoveDuplicates Method

Removes duplicate values from a range of values.

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

Syntax

'Declaration
Sub RemoveDuplicates ( _
    Columns As Object, _
    Header As XlYesNoGuess _
)

void RemoveDuplicates(
    Object Columns,
    XlYesNoGuess Header
)

Parameters

• Columns
  Type: System.Object

  Optional. Array of indices of the columns that contain the duplicate values. If blank, all columns will be searched for duplicate information.

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

  Optional. Specifies whether the first row contains header information. The default is xlNo. Use xlGuess if you want Excel to attempt to determine the header.

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace