Export (0) Print
Expand All
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.

Show:
© 2015 Microsoft