LeanAccountant
New Member
- Joined
- Jan 8, 2014
- Messages
- 2
I'm sure I've seen this somewhere before (so I apologise), but I can't seem to find the answer...
I'm trying to write code to act like a hyperlink and go to a target cell specified in a cell. For example, in Sheet 1 cell A1 could be displaying a value (or text) as a direct link to Sheet 2 cell G4 so I would like a macro to double click on Sheet A1 and jump to Sheet 2 G4. I've already used a double click formula a couple of times recently, but can't find a way to extract the formula from the cell and use that to go to the destination.
Although I plan to specify which cells (e.g. A1) the macro will act on, I presently need to specify the destination too (e.g. G4), but I would prefer to be able to specify the destination as a variable (i.e. whatever the cell contents are).
Thanks for any help/guidance.
I'm trying to write code to act like a hyperlink and go to a target cell specified in a cell. For example, in Sheet 1 cell A1 could be displaying a value (or text) as a direct link to Sheet 2 cell G4 so I would like a macro to double click on Sheet A1 and jump to Sheet 2 G4. I've already used a double click formula a couple of times recently, but can't find a way to extract the formula from the cell and use that to go to the destination.
Although I plan to specify which cells (e.g. A1) the macro will act on, I presently need to specify the destination too (e.g. G4), but I would prefer to be able to specify the destination as a variable (i.e. whatever the cell contents are).
Thanks for any help/guidance.
