hyperlink jump to location
I use hyperlinks to navigate to different locations in a single workbook, or different locations on the same work sheet. When I click the hyperlink and it jumps to the new location, the new active cell is always in the lower right hand corner (if out in the middle of the sheet) or in the lower left hand corner (if in the A column). Its like after the hyperlink jump I am presented the end of an area of information, not the beginning of the new area.
Is there a way to instruct Excel to present the active cell in the upper left hand corner of the screen upon the hyperlink jump?
Second question, Is there a way to specify a new hyperlink location in the same work sheet via a formula? in other words taking the current location and moving 22 cells down each time. I have a worksheet with 50 tables. I want to hyperlink a single cell in each table to create a "next button" that would move me to the next table. I know I can do this manually 50 times, but was hoping for (cell address +22 cells down) kind of formula in the new location bar.
Thanks....
|