So I'm using the Name Box and Defined Named Ranges as an index to jump around to different areas on my worksheet. I have noticed that some of the ranges, when selected via the name box, will put the top left cell of the range at the top left position on the screen (like cell A1 is on a new worksheet). However, other named ranges when selected, will not place the top left cell of the range at the top left of the screen and that cell ends up in the middle of the screen or to the right of center. I'm not sure why this is happening for some ranges and not for others. Is there a way I can set a property somewhere to have the cells at top left? I'd like to avoid using VBA for this, as it's just used to jump around the sheet to different areas without dragging the scroll bars and such.
Any insight would be appreciated - thank you!
Any insight would be appreciated - thank you!