tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,832
- Office Version
- 365
- 2019
- Platform
- Windows
In cell A1, I have the value google.co..uk
In cell A2, I have the text, "Click here"
What I want is for the user to click on cell A2 and it takes them to the webpage in cell A1, currently google.co.uk.
How can this be done?
I've tried typing:
in the Edit Hyperlinks Address box but it doesn't work.
Thanks
In cell A2, I have the text, "Click here"
What I want is for the user to click on cell A2 and it takes them to the webpage in cell A1, currently google.co.uk.
How can this be done?
I've tried typing:
Code:
=INDIRECT(A1)
in the Edit Hyperlinks Address box but it doesn't work.
Thanks