View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Help with Excel hyperlinks Help with Excel hyperlinks is offline
external usenet poster
 
Posts: 1
Default How can I hyperlink to a relative address in a worksheet?

I have built a work-in-process worksheet that I have linked to various
websites or email addresses, etc. One function that is not working for me
though is trying to link to another worksheet in the same workbook. I need
the hyperlink to be a relative address because I am continually resorting the
info in alpha order; so the cell I want to link to changes frequently. I
have tried naming the cell but to no avail. Can you help me?

Thanks,
Joan