Hi,

I have a hyperlink in my spreadsheet which opens to another worksheet in the
same spreadsheet. At the moment my formula is:
=HYPERLINK("[spreadsheetname.xls]NewWorksheetName!NewCell", "click this to
go to other worksheet")
Instead of using the spreadsheet name, can I use something which says "the
workbook im currently in"? so that if the name changes I wont need to change
the formula?
Ive tried [ThisWorkbook] and [Thisworkbook()] without success.
thanks for any help

cheers