Hyperlink not working...

[neilcarden]

Hi I have a multiple sheet workbook, and I want to create a hyperlink from one sheet to cell D98 on another sheet... I've named the cell 'link1'.

For some reason when I try to create the hyperlink, it's saying the 'Reference is not valid'...

I'm confused..

Thanks

[neilcarden]

OK, I've sorted... but how do I make that cell when hyperlinked and clicked to be at the top of the sheet?