NamedRange.RemoveDuplicates Method (Object, XlYesNoGuess)

 

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 = XlYesNoGuess.xlNo
)

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.

Return to top
Show: