Hi

have a question re Precedents in Excel. When I click a cell containg some
references to other worksheets a small icon shows up next to the cell. When
clicked it shows a Go to window with references (paths) to precedent cells
from other worksheets. I want to get that list of references using VBA. When
I record a macro it looks like this:

Sub Makro3()

Selection.ShowPrecedents
'I clicked the third position from the list
ActiveCell.NavigateArrow TowardPrecedent:=True, ArrowNumber:=1,
LinkNumber _
:=3
ActiveSheet.ClearArrows
End Sub

How can I get the reference that appears in this macro as LinkNumber:=3. I
want to use this in some other place in my code so I want to assign it to a
variable of string type.

Kind regards
Igor