DirectDependents Property

Applies To

Range object.

Description

Returns a Range object that represents the range containing all the direct dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. Read-only.

See Also

Dependents property, DirectPrecedents property, Precedents property, ShowDependents method.

Example

This example selects the direct dependents of cell A1 on Sheet1.

Worksheets("Sheet1").Activate
Range("A1").DirectDependents.Select