| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Activate Hyperlink in Named Range
I have Hperlinks to sheets in column A and numbers corresponding to the
location in Column B. I have three seperate sections of locations in column A that I've given a Range Name because some of the numbers are duplicates between the sections. I need to search, by section/named Range for the number in Column B, and if the number is found, activate the corresponding hyperlink in Column A. I tried using a macro to determine the physical row number within the named range, but it failed. I really need to get this fixed. Can anyone help? I've set up a Range OHAC using Insert/Name/Define with Offset/CountA (as the range will change!) starting at A32 counta A32:A44. The numbers are in Column B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Hyperlink in cells....how to activate it with out a mouse | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Activate cell at end of range | Setting up and Configuration of Excel | |||
| How do I de-activate hyperlink in Excel ? | New Users to Excel | |||
Threaded Mode
