View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DW DW is offline
external usenet poster
 
Posts: 11
Default Need hyperlink function to obtain range name from a cell (contents

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