View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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