Range.NavigateArrow (Excel)

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.

NavigateArrow (TowardPrecedent, ArrowNumber, LinkNumber)



The following arguments are optional

TowardPrecedent (Boolean) - Specifies the direction to navigate; True to navigate toward precedents, False to navigate toward dependents.

ArrowNumber - Specifies the arrow number to navigate; corresponds to the numbered reference in the cell's formula

LinkNumber - 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