Range.NavigateArrow Method
Navigates a tracer arrow for the specified range to the precedent, dependent, or error-causing cell or cells. Selects the precedent, dependent, or error cells and returns a Range object that represents the new selection. This method causes an error if it's applied to a cell without visible tracer arrows.
Syntax
expression.NavigateArrow(TowardPrecedent, ArrowNumber, LinkNumber)
expression A variable that represents a Range object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| TowardPrecedent | Optional | Variant | Specifies the direction to navigate: True to navigate toward precedents, False to navigate toward dependent. |
| ArrowNumber | Optional | Variant | Specifies the arrow number to navigate; corresponds to the numbered reference in the cell's formula. |
| LinkNumber | Optional | Variant | If the arrow is an external reference arrow, this argument indicates which external reference to follow. If this argument is omitted, the first external reference is followed. |
Return Value
Variant
Example
This example navigates along the first tracer arrow from cell A1 on Sheet1 toward the precedent cell. The example should be run on a worksheet containing a formula in cell A1 that includes references to cells D1, D2, and D3 (for example, the formula =D1*D2*D3). Before running the example, display the Auditing toolbar, select cell A1, and click the Trace Precedents button.
| Visual Basic for Applications |
|---|
|