Simple hyperlink question

[canadian86]

Hi,

I have a hyperlink in cell A1. When I click cell A1, it goes to cell D50.

I then added 100 lines above D50, so the value in D50 is now in D150.

When I click A1, it STILL goes to D50, not D150.

How do I create a hyperlink that remembers the cell and goes to that cell even if I move it anywhere in the worksheet or even a different worksheet?

Any ideas?

Thanks.

 

[daverunt]

Any good?

http://www.ozgrid.com/forum/showthread.php?t=49542&page=1