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.
expression.NavigateArrow (TowardPrecedent, ArrowNumber, LinkNumber)
expression A variable that represents a Range object.
|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.|
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