Skip to content

Latest commit

 

History

History
42 lines (25 loc) · 1010 Bytes

Excel.Range.DirectDependents.md

File metadata and controls

42 lines (25 loc) · 1010 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Range.DirectDependents property (Excel)
vbaxl10.chm144118
vbaxl10.chm144118
Excel.Range.DirectDependents
266b054e-6838-ffe7-14e2-e712a149e5be
05/10/2019
medium

Range.DirectDependents property (Excel)

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 Range object.

Syntax

expression.DirectDependents

expression A variable that represents a Range object.

Remarks

The DirectDependents property only works on the active sheet and cannot trace remote references.

Example

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

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

[!includeSupport and feedback]