NamedRange.RemoveDuplicates(Object, XlYesNoGuess) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 -> unitPublic 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.