hyperlink formulas in excel

to add a hyperlink formula in excel:

=HYPERLINK("#sheetname!"&CELL("address",A999))

 

where 'sheetname' is the name of the worksheet and

'A999' is the the cell to link to

 

the pound sign, # is _Necessary_