This documentation is archived and is not being maintained.

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

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
Show: