Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to Named Range Based On Cell Contents
I'm using the function below to make a hyperlink. The contents of 'A-Z
Inputs'!AN5 has a named range in it. =HYPERLINK('A-Z Inputs'!AN5) When I click on the hyperlink though, it says, "cannot open the specified file". For some reason, it wants a file instead of just looking in the current file for that range. I'd prefer to be able to do this with the function, but as a last option, I can do a macro. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to Named Range Based On Cell Contents
Try:
=HYPERLINK("#"&'A-Z Inputs'!AN5","Clickme") TKS_Mark wrote: I'm using the function below to make a hyperlink. The contents of 'A-Z Inputs'!AN5 has a named range in it. =HYPERLINK('A-Z Inputs'!AN5) When I click on the hyperlink though, it says, "cannot open the specified file". For some reason, it wants a file instead of just looking in the current file for that range. I'd prefer to be able to do this with the function, but as a last option, I can do a macro. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Q: Named range based on cell value? | Excel Discussion (Misc queries) | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Return entries from one named range based on the contents of another | Excel Worksheet Functions | |||
Reference Data Range based on cell contents | Charts and Charting in Excel |