Range.ShowPrecedents Method
| Excel Developer Reference |
Draws tracer arrows to the direct precedents of the range.
Syntax
expression.ShowPrecedents(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 precedents. False to expand one level of tracer arrows. The default value is False. |
Return Value
Variant
Example
This example draws tracer arrows to the precedents of the active cell on Sheet1.
| Visual Basic for Applications |
|---|
|
This example removes the tracer arrow for one level of precedents of the active cell on Sheet1.
| Visual Basic for Applications |
|---|
|
See Also