Returns a Range object that represents the range containing all the dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. Read-only Range object.
Syntax
expression.Dependents
expression A variable that represents a Range object.
Remarks
The Dependents property only works on the active sheet and cannot trace remote references.
Example
This example selects the dependents of cell A1 on Sheet1.
Worksheets("Sheet1").Activate
Range("A1").Dependents.Select