Share via


NamedRange.RemoveDuplicates(Object, XlYesNoGuess) Method

Definition

Removes duplicate values from a range of values.

public void RemoveDuplicates (object Columns, Microsoft.Office.Interop.Excel.XlYesNoGuess Header = Microsoft.Office.Interop.Excel.XlYesNoGuess.xlNo);
abstract member RemoveDuplicates : obj * Microsoft.Office.Interop.Excel.XlYesNoGuess -> unit
Public Sub RemoveDuplicates (Optional Columns As Object, Optional Header As XlYesNoGuess = Microsoft.Office.Interop.Excel.XlYesNoGuess.xlNo)

Parameters

Columns
Object

Optional. Array of indices of the columns that contain the duplicate values. If blank, all columns will be searched for duplicate information.

Header
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.

Applies to