Range.NavigateArrow(Object, Object, Object) Method
Definition
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 ObjectParameters
- 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.