Range.ColumnDifferences Method

Returns a Range object that represents all the cells whose contents are different from the comparison cell in each column.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function ColumnDifferences ( _
    Comparison As Object _
) As Range
'Usage
Dim instance As Range
Dim Comparison As Object
Dim returnValue As Range

returnValue = instance.ColumnDifferences(Comparison)

Range ColumnDifferences(
    Object Comparison
)

Parameters

• Comparison
  Type: System.Object

  Required Object. A single cell to compare to the specified range.

Return Value

Type: Microsoft.Office.Interop.Excel.Range

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace