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: Microsoft.Office.Interop.Excel.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