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

• 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

XmlMappedRange Interface

Microsoft.Office.Tools.Excel Namespace