Excel.Range.Dependents.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.Dependents property (Excel)	vbaxl10.chm144116	vbaxl10.chm144116	Excel.Range.Dependents	47813412-306a-0f99-3ca5-d354b16af468	05/10/2019	medium

Range.Dependents property (Excel)

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

[!includeSupport and feedback]