Dynamic Hyperlinks

I have a workbook with a contents page (call it A) with links to certain sections of another page(call it B), where the hyperlinks are created using the method in the screenshot

Is there any way to make the hyperlinks dynamic so if i delete rows or colums in B the hyperlinks in A will adjust themselves automatically?

If you link to a "defined name" (named range) instead of a cell reference, then the link will follow that location regardless of row/columns inserts and deletions.

If you are not familiar with named ranges I can provide more details if you tell us what version of Excel you are using.

i'm using excel 2003 [forgot that ]

EDIT: thanks for the hint. Figured it out myself

Originally Posted by lordfa9

just wondering; is there any way to ensure that when you click on the link, the destination cell will always be on the top left of the screen?

No, not unless you write some VBA to make it so.

BTW I suggest you edit your profile to show your version of Excel so you don't have to remember to include next time you start a thread.