Hyperlink to named range in workbook

R

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named Ranges and Dynamic Formulas 3
Hyperlink Function 10
Excel Macro to hyperlink an archived worksheet to an index page 0
Hyperlink to cell in separate workbook 3
Link to a named range in another worksheet that is sorted frequent 2
Hyperlink to Named Range Based On Cell Contents 1
Hyperlink text from linked workbook 1
HYPERLINK Worksheet Function 3

Top