Selecting a range using name box

MWSC18

New Member
Joined
Jan 25, 2018
Messages
5
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!
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

WassimN

New Member
Joined
Nov 3, 2017
Messages
44
Hello MWSC18

I am not sure there are any settings for a named range that you can change to make this happen. I am afraid VBA is the only way that I know of that will help in doing this. Maybe we will wait for someone wonderful Exceler who will teach us something new.

Sorry for the not so good news for now!

But if you do want some VBA code, then look into the Window Scroll and the selection change event so that the code will fire when a cell is selected.
 

MWSC18

New Member
Joined
Jan 25, 2018
Messages
5
Hi Wassim,

Thanks for replying. For now, I will just use the selection change vba code to position the selection as you suggested. I was trying to keep the code as lean as possible for this file, but I need the ranges to display correctly so I'll have to add it in.

It just seems strange that some of the ranges are placed at top left and others are not. I don't see a correlation between which ones do and which don't either... Seems completely random.

Gonna see if that wonderful Exceler comes along... :)
 

Watch MrExcel Video

Forum statistics

Threads
1,099,548
Messages
5,469,360
Members
406,647
Latest member
ssinovec

This Week's Hot Topics

Top