HyperLinks
Suppose you want to jump to cell C25 in Sheet2 - you could have a
formula like this somewhere in Sheet1:
=HYPERLINK("#Sheet2!C"&ROWS(Sheet2!A1:A25))
and this will show "#Sheet2!C25" in the cell, which if you click on
it, will take you to that cell. Now if you insert, say, four new rows
in Sheet2 somewhere between row 1 and row 25 then the formula will
automatically adjust and the cell will show "#Sheet2!C29", and that's
where you will jump to.
However, if you insert rows after row 25 then the formula will not
change - I think this is what you wanted. Inserting rows in Sheet1
will have no effect (other than maybe moving the formula down).
Hope this helps.
Pete
On Oct 29, 9:21*pm, Jerry Foley
wrote:
How do I program the hyperlinks to be relative? In other words, I have
hyperliks programmed for other tabs of the same workbook. When I insert a new
row or rows, the cell definition in the actual hyperlink on the Table of
Contents tab does not change.
Thanks
|