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