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