Range.RowDifferences method (Excel)

Artikkeli
09/13/2021

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.

Jaa