Edit

Share via


Range.NavigateArrow(Object, Object, Object) Method

Definition

Navigates a tracer arrow for the specified range to the precedent, dependent, or error-causing cell or cells.

public object NavigateArrow (object TowardPrecedent, object ArrowNumber, object LinkNumber);
Public Function NavigateArrow (Optional TowardPrecedent As Object, Optional ArrowNumber As Object, Optional LinkNumber As Object) As Object

Parameters

TowardPrecedent
Object

Optional Object. Specifies the direction to navigate: True to navigate toward precedents; False to navigate toward dependent.

ArrowNumber
Object

Optional Object. Specifies the arrow number to navigate; corresponds to the numbered reference in the cell's formula.

LinkNumber
Object

Optional Object. 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.

Returns

Remarks

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.

Applies to