Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi:
I want to set up a hyperlink to a named range. I have to set up about 2000 hyperlinks and I need to have the hyperlink obtain the range name from a cell in the same worksheet. For example I will have range names entered into cells B1:B5. I want to set up hyperlinks in cells C1:C5 that go to column B, in the same row, pick up the range name and then send the user to the range based on that name. I would be grateful for any help I can obtain. Thanks DW |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink to Named Range Based On Cell Contents | Excel Worksheet Functions | |||
Syntax to obtain the SubAddress of a Hyperlink in A1 on Sheet1 | Excel Discussion (Misc queries) | |||
hyperlink using cell contents | Excel Worksheet Functions | |||
How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
How can I shift cell range contents by using a function? | Excel Worksheet Functions |