index page

[henry]

Hi,

I have set up an index page. Across the top I have the alphabet with
each letter linked to the correct section within the index list. I've
done this by defining names for each letter. The problem I have is that
I'd like to, say, click on "D" and have cursor to jump to the "D"
section, and have the "D" section move to the top of the page, but I
always seem to be going to the bottom of a page and then needing to
scroll. Any suggestions?

 

[Bob Phillips]

Show us the code.


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[damorrison]

Try a couple of things like:

Range("G22").Select
Application.ScreenUpdating = False
ActiveWindow.ScrollColumn = Range("G22").Column
ActiveWindow.ScrollRow = Range("G22").Row
Application.ScreenUpdating = True
this will take you to the top left of you screen you can type in the
range like ("G1:G44") or the range name("SectionD")

Another way is to make your index selections into hyper links
select the cell with the selection, press ctrl&K and experiment....
Dave