set view to top of worksheet

[Noz2k]

Is there a way to set the screen view to the top of a worksheet?

I have a few buttons which all open the same sheet, however the visibilities are different. So in some instances there will be no data beyond row 50, but the sheet will open and be at cell 500 as that's where was scrolled down to previously.

 

[Michael M]

If I understand you correctly, you could use the line

Range("A1").activate

at the end of each button code.

 

[Noz2k]

I thought that, but it didn't seem to do the trick when I tried.

I also attempted Range("A1").Select, but whilst it selected the cell it didn't move the screen up

 

[Michael M]

Are you saying when you run the code with Range("A1").activate it doesn't go to Range A1 ??
If it doesn't where does it go ?
If it goes somewhere else, you may have to post the code !!
Works fine for me !

 

[VoG]

Try

Application.Goto Range("A1"), True

 

[Noz2k]

It just remained where it was.

But you're right it did work. The problem was that when I tried it, I didn't have it right at the bottom of all my code, and it was before I had re-enabled screen updating.

Also for the record VoG, your way worked for me to.

Thank you both for helping

 

[Michael M]

Glad it worked....I was starting to think the Excel gremlins were out tonight !!