Share via


XmlMappedRange.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

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

    An XlYesNoGuess that 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.

.NET Framework Security

See Also

Reference

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace