Perhaps an alternative to play with, using the "barebones" sub below
(Just tinkered around with the macro recorder)
Steps:
Press Alt+F11 to go to VBE
Click Insert Module
Copy paste everything within the dotted lines below
into the code window (whitespace) on the right
'-----
Sub JumpToLinkCell()
ActiveCell.ShowPrecedents
ActiveCell.NavigateArrow TowardPrecedent:=True, _
ArrowNumber:=1, LinkNumber:=1
End Sub
'----
In Excel, press Alt+F8
Select "JumpToLinkCell" in the macro list
Click "Options"
Enter a "j" for the shortcut key OK
Test it out. Select a cell with a link formula to another sheet in the same
book. Press CTRL+j to run, and you'll be zapped instantly to the source
cell in the linked sheet. (Need to go back & clear the arrows later, though
...)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---