How do you hyperlink a cell address to top of page?

  • Thread starter Thread starter Enigman O'Maly
  • Start date Start date
E

Enigman O'Maly

I'm working on a multi-sheet app which has a lot of hyperlinks to go back &
froth. There are also links to jump to different sections of the main sheet.
Admittedly, it's a minor complaint, but often the link will jump so that the
targeted cell is at the bottom of the screen instead of the top. How can one
force it to position the target cell at the top?
 
You can cheat, and do a double-loopback sort of thing........set up a macro
to do a "Goto" that is about 50 cells below your target cell and about 20
cells to the right (or more) and go there first, and then as a second step
"goto" your original target cell and Excel will place your target cell in
the upper left hand corner of the screen........


Vaya con Dios,
Chuck, CABGx3
 
Back
Top