Expand Minimize
This topic has not yet been rated - Rate this topic

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.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.