Hi Rich
Try this
=HYPERLINK("http://" & Sheet2!A2)
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Rich Gibbons" wrote in message ...
Thats great and works when typing it on the sheet, but unfortunity it doesn't
work when i refer to another to another sheet. So the cell that i want to
hyperlink is A2 it has a formula in it of: =IF('Sheet2'!A2=
"","",'Sheet2'!A2), can i still make this cell into a hyperlink?
I have tried making the data in sheet2 a hyperlink and then linking that but
still doesn't work, any sugestions?
Rich