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