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