Cannot scroll to bottom of Scroll Area.

[smiley3141]

I have a sheet that has data in the range A1:K1077. I set the scroll area in VBA to "A1:K1078". This macro runs each time I activate the tab. The first time it runs, I can see the whole scroll area. After that it cuts me off and I cannot scroll down and see the last 7 or 8 lines. I have increased the scroll area all the way up to row 1300, and this does not resolve the problem. Does anyone know what the problem might be and a possible solution?

I have thought of hiding all the rows below 1078, but when I set the scroll area to the first 1078 rows and hid the bottom, it allowed me to scroll past the bottom and see a blank gray area. I do not want that.

It is getting late here, so if you respond it might take a while for me to get back to you.

Thanks for any help you can offer me.

 

[Andrew Poulsom]

You would have to use the scroll bar to reach the bottom. Or change the mouse wheel's number of lines to scroll to 1.

 

[parara]

[...] Or change the mouse wheel's number of lines to scroll to 1.

Which is a Windows setting, i.e. can't be done from inside Excel, right?

 

[Andrew Poulsom]

No it can't be done in the Excel user interface.

 

[smiley3141]

Andrew, sorry about the delay. Also, I was tired and gave you some bad information the other night. PS_Unhide is currently 10:1064 and PS_Hide is 833:1051. Hope that answers all your questions and you can figure out what is going on.

Parara - thanks for the information regarding the mouse wheel number. Unfortunately, this cannot be my problem, since I tried extending the scroll area a couple hundred extra rows and it did not help.