I am trying to write a macro to take me to the cell referenced in the ActiveCell formula.
I am using the following script:
Application.Goto Reference:= Active Cell.Formula while in the active cell I have : =Sheet2!A1
The macro is not working; when I recorded it to see how excel handles this, I realized that Excel would add "]" and it appears as: "=Sheet2!R[1]C[1]"
How can I achieve what I am trying to do?
Thanks
Bookmarks