Microsoft Knowledge Base

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

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

   =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.

REFERENCES

For more information about the NavigateArrow Method, choose the Search button in Help and type:

   NavigateArrow Method