smiley3141
Board Regular
- Joined
- Aug 13, 2010
- Messages
- 77
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.
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.