View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
LostnSpace
 
Posts: n/a
Default Loosing correct hyperlnk location after sorting spreadsheet da

Naming the cell and using the defined name as the hyperlink does handle the
ability to change row location using a cut & paste. I was hoping identify a
solution where I could use a sort function.

Thanks much for your reply.

"flummi" wrote:

It doesn't work with sort. However, if you NAME the cell you are
pointing to and in your hyperlink choose "defined names" and the name
you specified, it will at least take care of manual movements.

Hans