Thread: [Solved] hyperlink jump to location
View Single Post
 
Old 01-10-2015, 04:39 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

(First question only:) I don't use hyperlinks inside Excel much. (Actually I'm not sure I ever have, though I do it often enough in Word.) But when I experimented with it just now, the new active cell was in the upper left. Before I hit the link, the target sheet was several pages down from the top, and I made the target R13C2. I infer that Excel scrolled up to activate the new cell, and stopped once the new cell was visible. If I'm right, that implies that in your case the target sheet was active above the target cell, and had to scroll down.

...Further experimentation yields one solution for you: Set the target to a range, not a single cell. That causes Excel at least to scroll down enough to display the entire range. The entire range is selected, too, which may be a disadvantage....
Reply With Quote