Export (0) Print
Expand All

Range.RowDifferences Method

Office 2007
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

NameRequired/OptionalData TypeDescription
ComparisonRequiredVariantA 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.

Visual Basic for Applications
Worksheets("Sheet1").Activate
Set c1 = ActiveSheet.Rows(1).RowDifferences( _
    comparison:=ActiveSheet.Range("D1"))
c1.Select



Community Additions

ADD
Show:
© 2014 Microsoft