Range.RowDifferences method (Excel)
Returns a Range object that represents all the cells whose contents are different from those of the comparison cell in each row.
expression A variable that represents a Range object.
|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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.