reset extent of page/scroll bars

Posted by Brad G. on September 21, 2001 3:01 PM

How can you "reset" a sheet as far as its total area? I have a workbook that I dump data to that can vary greatly in number of rows. If I drop 4000 rows into a sheet one day and then only 200 the next day, the scroll bars still "think" that there are 4000 there. Even filters and sorting take longer because they are considering mostly unpopulated rows.

Posted by Francisco on September 21, 2001 4:03 PM

Have a look at :-
http://www.j-walk.com/ss/excel/tips/tip73.htm

You could put the code in a normal macro instead of in the suggested event procedures.

Posted by Ivan F Moala on September 21, 2001 4:07 PM

Run a macro that has this in the last line

Sub Reset()
ActiveSheet.UsedRange
End Sub

Ivan