Is this possible at all?? The forumla i have is;
The cell G7 will have a postcode in this and i would like it to be a 'clickable' link so if once they put the postcode in they just can click to bring up IE with that web address!!
="http://maps.google.co.uk/maps?hl=en&q="&G7&"&ie=UTF-8&sa=N&tab=wl"
See HYPERLINK function, ie:
=HYPERLINK("http://maps.google.co.uk/maps?hl=en&q="&G7&"&ie=UTF-8&sa=N&tab=wl",G7)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
or click INSERT --> HYPERLINK which is also CTRL + K on your keyboard
Click here to read the Forum Rules
Whatever it is in life you decide to go after, go after with great ferocity.
scaffdog, the URL is itself dynamic by means of a variable (G7)
You can hyperlink almost anywhere
Add this into a cell, its what i generally do
=HYPERLINK("#"&CELL("address",Sheet2!A1))
Now the cell will read - #[Book1]Sheet2!$A$1 this is expected
Yep, in this case though the link is a URL - hence post #2Originally Posted by Jack in the UK
I should have read it a bit more thouroughly. Nice for future use!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks