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.
Syntax
expression .RowDifferences(Comparison)
expression A variable that represents a Range object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Comparison |
Required |
Variant |
A single cell to compare with the specified range. |
Return Value
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