RowDifferences Method

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

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