=HYPERLINK("#" & ADDRESS(ROW()+41,1,4),"next week")

Will allow you to put the formula on any cell in the row ,
the link will take you 41 rows below and to the first column.
--
---
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

"kimare" wrote in message ...

=HYPERLINK("#a123"; "Next week")

The first week is placed on a123, then the second 41 rows under at
a164, and then third further 41 rows down at 205. Is there a formula I
could use in this case.


--
kimare
------------------------------------------------------------------------
kimare's Profile: http://www.excelforum.com/member.php...o&userid=16501
View this thread: http://www.excelforum.com/showthread...hreadid=320384