Edit

Range.RowDifferences method (Excel)

  • Article

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

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.