View Single Post
  #8   Report Post  
Dave Peterson
 
Posts: n/a
Default

You could define a range name, then link to that.

Give Sheet1!C17 a nice range name.

Then you can link to that defined name (insert|hyperlink has an option for Place
in this document).

Or you could use a worksheet formula:
=HYPERLINK("#testname1")



Samad wrote:

When I Hyperlink cells to another sheet's cell and when I move data to other
row/ column or I insert rows/column it does not move hyperlinked address.

Can anyone advice me how to move hyperlink address with insert/move
rows/column/cells.
Thanks


--

Dave Peterson