Returning to 'calling' hyperlink cell from another hyperlink.
Posted on 2002-05-01
I'm sure this is quite easy to explain, but as usual I’ll drag it out a bit :) sorry.
In sheet1 of excel I have hyperlinks to sheet2. In sheet 2 I have one hyperlink "BACK".
How do I make the BACK hyperlink go to the cell in sheet1 that just called it? The problem is that the cells in sheet1 that contain the hyperlinks to sheet2 are likely to move about so no 'hard coding' of cell references is possible.
I have tried to think of a way top make VB do this but failed so I turned to the Microsoft Script Editor, but that's written in Java (at a guess) and I’m even worse with that than I am with VB.
Can anyone make a suggestion of how to do this or if I’ve made myself unclear please post a comment or two asking me questions.