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