Hi Nba,

Can you hyperlink to a cell reference using a formula result?

Yes, by using the HYPERLINK worksheet function.

=HYPERLINK("#'Sheet1'!$A1") points to sheet1, cell A1.

As you can see the syntax is simple as long as you prepend the address with a #
and surround the sheetname with single quotes to ensure it works for sheets
with e.g. a space in their name.

That way, you can have the sheetname in a separate cell:

=HYPERLINK("#'" & B1 & "'!A1")

will point to a cell on the worksheet who's name you enter in cell B1.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com