PDA

View Full Version : Solved: Scroll Bar Length



CaptRon
07-05-2007, 07:09 AM
There is probably a simple solution to this that I am overlooking, but its driving me NUTS! :banghead:

On the several worksheets in a workbook, the length of the scroll bar varies depending on the area of the sheet that is utilized. If the scroll area is large the scroll bar length is diminished. Fine.

But sometimes something is clearly out of whack here. My scroll area should not extend to row 9000 (row 759 max). I end up with a scroll bar on this sheet nearly invisible but two inches long on the other sheets.

Is there a way to get these scroll bars more uniformly sized? How do I tell Excel there's nothing down there? I've tried just deleting the rows. Takes forever and hasn't worked.

Thanks.

Ron :thinking:

Bob Phillips
07-05-2007, 08:15 AM
Probably caused by the usedrange not being properly reset. See http://www.contextures.com/xlfaqApp.html#Unused

CaptRon
07-05-2007, 04:12 PM
The link you gave me provided the solution I needed. Thank you very much.

Ron