Expand Minimize

NamedRange.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)

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

Community Additions

ADD
Show:
© 2015 Microsoft