Solved: Scroll Bar Length

[CaptRon]

There is probably a simple solution to this that I am overlooking, but its driving me NUTS!

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

[Bob Phillips]

Probably caused by the usedrange not being properly reset. See http://www.contextures.com/xlfaqApp.html#Unused

[CaptRon]

The link you gave me provided the solution I needed. Thank you very much.

Ron