Hyperlink to named range in workbook

[Raj]

Hi,

I am using the formula: =HYPERLINK("[Workbook1.xls]Sheet2!
namedrange","Click here") to create a hyperlink with text "Click here"
in cell A1 of Sheet1. Clicking on the hyperlink takes the user to the
Range named "namedrange" on Sheet2. This ensures that addition or
deletion of rows/columns in Sheet2 does not change the target of the
hyperlink.

The problem is this: The hyperlink stops working if the Workbook name
or the Worksheet name is changed. Is there a way of making the
hyperlink work by suitably modifying the formula to take care of
changed workbook/worksheet names?

Thanks in advance for the help.

Regards,
Raj

 

[Bernie Deitrick]

Raj,

Instead of the HYPERLINK function, insert a hyperlink to the named range using the dialog Insert /
Hyperlink.... Place in this Document / Defined Names

HTH,
Bernie
MS Excel MVP