Can you share why the second version didn't point at B504 directly instead of
using offset().



nastech wrote:

Thanks.. getting few items to check out for dynamic ranges etc.
Have others that were looking for answer such as this hyperlink, do you
think my example is complete, or any extraneous items.. or did I accidently
get it right :)?

=HYPERLINK("#"&CELL("address",OFFSET(A505,$Z$1,1)) ,"P2") for downwards
=HYPERLINK("#"&CELL("address",OFFSET(A505,-1,1)),"P2") for up

for:
=HYPERLINK("#"&CELL("address",

--

Dave Peterson