Scroll bar active area is too big

Posted by Bryce Templeton on December 07, 2000 5:25 PM

I accidently scrolled down 8000 lines on a 500 line sheet (It has to do with a cat). Now the scroll bar indicator is all scrunged up at the top as it thinks all 8000 lines are part of the sheet. Can this be reset?

Posted by Ivan Moala on December 07, 2000 6:14 PM

You could try resetting the range via code

Sub Reset_Range()
ActiveSheet.UsedRange
End Sub

I think this will work

Ivan