NamedRange.RemoveDuplicates Method (2007 System)

Removes duplicate values from a range of values.

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

Syntax

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

'Usage
Dim instance As NamedRange 
Dim Columns As Object 
Dim Header As XlYesNoGuess

instance.RemoveDuplicates(Columns, Header)

public void RemoveDuplicates(
    Object Columns,
    XlYesNoGuess Header
)

public:
void RemoveDuplicates(
    Object^ Columns, 
    XlYesNoGuess Header
)

public function RemoveDuplicates(
    Columns : Object, 
    Header : XlYesNoGuess
)

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

• 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 Class

NamedRange Members

Microsoft.Office.Tools.Excel Namespace