Hyperlink to specific number of rows above

[ddub25]

I want to create a hyperlink that will simply take me to 33 rows above the hyperlink. Can anyone help me witht the code for that. Thanks in advance.

 

[Gary's Student]

Try:

=HYPERLINK("#" & ADDRESS(ROW()-33,COLUMN()),"Jump above")

​You can adjust the 33 to adjust to destination row.

 

[ddub25]

Thanks very much, that's very useful.

Dan