Range.RowDifferences (Excel)

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

RowDifferences (Comparison)

Comparison: A single cell to compare with the specified range.

Dim rngRowDifferences As Range
Set rngRowDifferences = ActiveCell.RowDifferences(Comparison:=)