Microsoft KB Archive/117315

= Microsoft Knowledge Base =

XL: "NavigateArrow Method of Range Class Failed" Error
Last reviewed: March 27, 1997

Article ID: Q117315

5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbusage

The information in this article applies to:


 * Microsoft Excel for Windows 95, versions 7.0, 7.0a
 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS
In Microsoft Excel, when you run a Visual Basic procedure that contains the NavigateArrow method, you receive the following error message:

Run-time error '1004':

NavigateArrow method of Range class failed When you run a macro on a MS Excel 4.0 Macro sheet that contains the TRACER.NAVIGATE function, you receive a macro error at the cell with this function.

CAUSE
This error appears when you use the NavigateArrow method without the arrowNumber argument, or the TRACER.NAVIGATE function without the arrow_num argument even though this argument is documented as an optional argument, and should not be required.

The Visual Basic Reference states that if you omit the arrowNumber argument, the arrowNumber value is assumed to be 1. However, if you omit the arrowNumber argument, you receive the error message above.

The Microsoft Excel Macro Functions Help states that the arrow_num default value is 1. However, if you omit the arrow_num argument, you receive a macro error at the cell that contains the TRACER.NAVIGATE function.

WORKAROUNDS
To avoid this error message when you use the NavigateArrow method in a Visual Basic procedure, include the arrowNumber argument as in the following example:

ActiveCell.NavigateArrow True, 1 To avoid this error message when you use the TRACER.NAVIGATE function on a MS Excel 4.0 Macro sheet, include the arrow_num argument as in the following example:

=TRACER.NAVIGATE(TRUE,1)

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
You can use the NavigateArrow method to select the precedent, dependent, or error-causing cell or cells for the specified range when a tracer arrow is displayed between the two ranges. It is the equivalent action to double-clicking a tracer arrow on a worksheet.

The NavigateArrow method has the named arguments towardPrecedent, arrowNumber, and linkNumber; and only the towardPrecedent argument should be required. However, if you do not also include a value for the arrowNumber, which is the number of the arrow you want to "navigate," you receive the error message described above.