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)
Syntax
'Declaration
Sub RemoveDuplicates ( _
Columns As Object, _
Header As XlYesNoGuess _
)
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.
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.