Please describe what it is that you want to happen, or what is happening that
you don't want to happen with an exact description of how to reproduce you
problem. There are object hyperlinks, and there is HYPERLINK Worksheet Function.

If you delete the row that hyperlink pointed to you are going to get an error,
so what would you want to happen instead.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"AGK" wrote in message ...
How can I retain the hyperlink target cell when adding or deleting rows in
the target sheet?