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: 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

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace