Hi,

I am trying to use the NavigateArrow method in VBA and I am not clear on the
meaning of a parameter for this method -- that of "ArrowNumber". VBA help
for Excel 2003 notes that "ArrowNumber...corresponds to the numbered
referenced in the cell's formula." Could anyone provide some additional
context on the meaning of this statement?

I tried using something similar to this code "Selection.NavigateArrow(True,
1)" in which the selected cell contained the formula "=B11+B13". I assigned
a variable to the above code and "debug.printed" the address of the
referenced cell, expecting to see "B11" as this is the first cell reference,
but instead VBA returned "B13". Why is this the case?

Thanks in advance for help with this issue.