Visible screen after clicking button

[bjd1566]

I have a file where the user clicks on a button that compresses the rows to only show the desired information. After they click on the button the rows compress, but the focus of the screen stays in one place.

Is there a way that I can have the focus move to the section of the worksheet that has just been compressed?

Is the focus not moving because I have screen-updating set to false?

Thanks.

 

[QuietRiot]

where do you want the focus to be?

 

[QuietRiot]

how does it know whats to compress

if you can get a row # from that code then you can just

ActiveWindow.ScrollRow = 2000 <===== the first row compressed

 

[bjd1566]

Thanks, it worked!