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 dependents. |
| 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, select cell A1, and on the Formulas tab, in the Formula Auditing group, select Trace Precedents.
Worksheets("Sheet1").Activate
Range("A1").Select
ActiveCell.NavigateArrow True, 1