RowDifferences Method

Microsoft Excel Visual Basic

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

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.

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