Move Top of screen to Cell

N

NateBuckley

Hello, I have a rather long Sheet, that has different days. I'd like some
buttons where you click it and it will move to that day (scrolls down so the
day is at the top of the page)

I've been doing it in a dodgy way by just recording the mouse scroll. I
thought there might be a better way, perhaps like a HTML anchor?

Cheers
 
T

Trevor Williams

Hi Nate,

Edit your Macro to read:

ActiveWindow.ScrollRow = 45

where 45 is the row number you want to be at the top of your screen.

HTH
Trevor Williams
 
J

Joel

Set a named range to the start location and then use GO TO. You can use on
the worksheet edit menu the GO TO.

or

Application.Goto Reference:=Worksheets("Sheet1").Range("A154"), _
scroll:=True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make buttons move when scrolling 5
Move data to top of column 1
SCROLL ON CELL CHANGE 3
Move around excel sheet 2
Freezing panes and the top of the screen 4
Scroll to Top of Sheet, When Sheet is FIRST Activated 3
cell top of screen 22
DREAM FEATURE: A macro that moves a row but asks me where to move it 18

Top