The cell contents originally were simply the url beginning with www. etc
I've put your
VB routine in and run that, and now when I hover over the cell
the link begins with file:///\\www. etc whereas with the previously suggested
VB script, the link began with c:/// etc
I don't know anything about
VB so I daren't fiddle with what you told me to
cut and paste.
I haven't yet tried using the worksheet function, I'll try that now.