That =hyperlink() uses the value returned.

If your returned value isn't a valid hyperlink, then maybe you could convert it
to one:

=hyperlink("http://" & yourformula)

If the value returned was missing the http:// portion.

If that doesn't work, what do you see in the cell?

"Gav via OfficeKB.com" wrote:

Cheers Dave, but that didnt work, it gave a hyperlink, but didnt have an
address to go to.

Any other suggestions?

Gav

--
Message posted via http://www.officekb.com

--

Dave Peterson