Range.Dependents Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

expression .Dependents

expression A variable that represents a Range object.

The Dependents property only works on the active sheet and can not trace remote references.

This example selects the dependents of cell A1 on Sheet1.



Other resources