Excel automatic Evaluate Formula Step-in links

[tjohannvr]

Hi there

I'm working in Excel 2007 and have links of the following format in cells:

='2002'!$J$11

If I go to the menu Formulas -> Evaluate Formula -> Step in then
I can go to the source of the data in the formula.

Is there a more automatic way in which to achieve this? I would
like to, say, double click on the cell containing the formula above and that should take me to the correct sheet.

Thanks for your time and help

TJ van Rooyen

 

[timumich]

As long as you select the desired cell first, this should work (apply a shortcut to this Macro and then you'll be all set):

Sub GoToSource()
'
' GoToSource Macro
'
Dim source As String
source = Mid(ActiveCell.FormulaR1C1, 2)

Application.Goto Reference:=source
'
End Sub

Let me know if you have problems.
cheers.

 

[tjohannvr]

Thanks for the fast reply.

I was unable to access the reply at first because there were a server/database
error.

It works perfectly, thank you.

Regards