SCROLL AREA

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
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]
 
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.
 
Upvote 0
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).
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top