Expand Minimize

NamedRange.RemoveDuplicates Method

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

Removes duplicate values from a range of values.

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

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft