Range.ShowDependents Method
| Excel Developer Reference |
Draws tracer arrows to the direct dependents of the range.
Syntax
expression.ShowDependents(Remove)
expression A variable that represents a Range object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Remove | Optional | Variant | True to remove one level of tracer arrows to direct dependents. False to expand one level of tracer arrows. The default value is False. |
Return Value
Variant
Example
This example draws tracer arrows to dependents of the active cell on Sheet1.
| Visual Basic for Applications |
|---|
|
This example removes the tracer arrow for one level of dependents of the active cell on Sheet1.
| Visual Basic for Applications |
|---|
|
See Also