RowDifferences Method

Applies To

Range object.

Description

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

Syntax

expression.RowDifferences(Comparison)

expression Required. An expression that returns a range containing the cells to be compared.

Comparison Required Variant. A single cell to compare with the specified range.

See Also

ColumnDifferences method.

Example

This example selects the cells in row one on Sheet1 whose contents are different from those of cell D1.

Worksheets("Sheet1").Activate
Set c1 = ActiveSheet.Rows(1).RowDifferences( _
    comparison:=ActiveSheet.Range("D1"))
c1.Select