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.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