Share via


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

Array of indexes of the columns that contain the duplicate information. If nothing is passed then it assumes all columns contain duplicate information.

Header
XlYesNoGuess

An XlYesNoGuess that specifies whether the first row contains header information. xlNo is the default value; specify xlGuess if you want Excel to attempt to determine the header.

Applies to