Home ยป Range.RowDifferences method
Learn
Go To Special with VBA
You can use Excel VBA to quickly find and select all cells that contain a specific type of data, just like using the Go To Specials command.
Docs
Range.RowDifferences method
Returns a Range object that represents all the cells whose contents are different from those of the comparison cell in each row. […]