Nameing cells in workbook

[Mike Busch]

I am naming cells so they will be easier to find via a drop-down menu. I have
the cell which is the title of one of 85 sites I need to look at from time to
time. I place the title of the site on the top left area of the workbook, and
then select it, go to insert/define/add the name of the site. When I try to
go to this site it comes up on the very bottom of the viewable cells on the
page. I would rather it come up on the top where I first selected the name
when I added it. Now that I have all 85 titles in the naming dropdown, is
there an easy way to make then appear on the top of the page so I don't have
to scroll to see the contents of the site.
Thank you in advance.

 

[Gord Dibben]

Mike3

Always better if you use cell references rather than "top left" and "top of
the page".

Assume you entered a title "Dept" in A1 then named A1 as "Dept"

No quotes in either case.

Scroll down to F56 and select it.

Now in the NameBox you select "Dept"

Where do you wind up?


Gord Dibben MS Excel MVP

 

[Mike Busch]

I tried selecting the cell in the A1 position thinking that when I called for
it, that is where it would appear on the application. But I tried to have
everyone that I selected in the A1 position and still when I call for them,
some appear in the A1 position and other appear in the A34 position, there
seems to be not rhyme or reason, as to where that appear. I and trying to do
this because I didn't want to scroll over the entire document, but is this
case I still have to scroll when they appear in A34.

 

[Gord Dibben]

OK, now I see.

You want whichever name is selected to scroll to top of sheet.

I mis-read your original.

You need VBA to do that.

sub gotoname
rname = InputBox("type a name")
Application.Goto Reference:=rname, Scroll:=True
End Sub

I'm sure there must be a way to select a name from the namebox and do same
thing without the typing but it escapes me right now.

Hang around, we'll get some help.


Gord Dibben MS Excel MVP