Range.NavigateArrow(Object, Object, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

Object

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