having trouble locking hyperlinks in excel
A formula like:
=HYPERLINK("#Sheet2!I14","go")
will lock to the absolute address. So if you add rows before row 4, it will
always go to the fourth row. However:
The following uses the HYPERLINK() function to goto Sheet3 cell Z100:
=HYPERLINK("#"&CELL("address",Sheet3!Z100),"target ")
This link will "adjust". So if you add or remove rows above Z100, the
formula will adjust!
--
Gary''s Student - gsnu200713
|