Move view to a certain range of cells

[Ajohn403]

Hi!
I'm trying to get this button working right. Basically, when I click the button I want to have the view of the sheet moved to the range in the macro (Z7:AI7)
and it works great the first time its clicked!
but every time afterwards, the view doesn't move to that range, it just moves the selected cell to AA6

Please Login or Register  to view this content.

That's the code im using

[ggs22]

I don't know why you want to select Range("AA6") after. Could this work?

Please Login or Register  to view this content.

[Ajohn403]

I don't know why you want to select Range("AA6") after. Could this work?

AA6 is where the data entry would begin, and I just tried that and the same thing happened,
It's as if activewindow.zoom only works one time

[ggs22]

Just to make it clear, activewindow.zoom=true adjust the zoom to the current selection (i.e. if a single cell is selected, zoom will increase to 400%) it doesn't move the focus. Normally, range.activate and range.select automatically move the view to that range. So that would be why Range("AA6").select moved the view back to that cell.

If I am not helping, please give more details about the expected behavior of the code.

[Ajohn403]

After the first time pressing the button:
firs press.png
After the second time pressing the button:
second press.png

It works the first time, but after the zoom is changed that first time it no longer works
what I'm wanting to know is how I can make it work every time the button is pressed

[ggs22]

Ok now I understand, try this:

Please Login or Register  to view this content.

[Ajohn403]

Worked great, though 20 made it look really glitchy (though it isn't) so i bumped it up to 80 (closer to the final result)
Thanks!
Solved