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)

C#
C++
F#
VB
Copy 
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: