SCROLL AREA

[verluc]

I have an excel sheets with the following code in Sub Workbook-Open:
Sroll area A5:K104
By opening this workbook I can only go with the mouse scrol-wheel until rownumber 102.I don't can go to the last row.
I can only reach the last two rows with the arrow button or the vertical bar.
Any idea why not with the mouse wheel?
Thanks[/img]

 

[Andrew Poulsom]

For me the behaviour with the mouse wheel is a bit erratic. It depends on where you start from and how many full pages of data there are in your scroll area.

I found that when I got near the bottom, scrolling toggled the visibilty of the last couple of rows.

 

[MisterCrash]

If your mouse wheel is set to scroll down 3 rows per notch (which is the default), then you probably wouldn't be able to scroll down from row 102 (since that would make row 105 visible, which is prohibited by your constraint).