I am inserting hyperlinks in my file. No problem with setting up a
range linked to the hyperlink, so that the cursor jumps to the range.
(I am doing the hyperlinks from a set of instruction headings at the
top of a sheet, to the actual paragraphs further down the sheet that
explain certain things in the model.)

What I find is that the cursor lands on the correct spot, but this
spot is at the bottom of the screen, so the user has to do a page down
to see the paragraphs that follow. Is there a way to make the place
where the cursor lands shift automatically so that it is at the top
left of the screen?