Absolute Cell Reference in a Hyperlink within the the same workbook

All:

I have a workbook with many tabs and within those tabs there are many hyperlinks to other areas within the same workbook. When I add or delete lines or rows, the corresponding hyperlinks do not stay with the changed cell. Is there any way to make the cell reference in a hyperlink an absolute similar to how you do with a formula?

Any help is greatly appreciated.

Thank you!

What's the difference between this thread and the one you posted 9 minutes earlier?

This is a duplicate post and as such does not comply with Rule 5 of the forum rules.

I'm sure a Moderator will come along soon and block one of your duplicate posts.

Pete