Not
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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.