Hyperlink TexttoDisplay
Not according to what he showed as the contents of M21
. . . M21 with
="http://uk.multimap.com/map/places.cgi?quicksearch="&E21
--
Regards,
Tom Ogilvy
"dowensan" wrote in message
...
Good call Tom but to work as James intended (I think) you would have to
change your code to
=hyperlink(M1 & E21,E21)
"Tom Ogilvy" wrote:
Why reinvent the wheel. Use the built in worksheet function
hyperlink
=hyperlink(M1,E21)
Apparently writing your own has masked the true built in
worksheetfunction.
You will probably need to remove your code.
--
Regards,
Tom Ogilvy
|