SCROLL BAR ISSUE

  • Thread starter Thread starter William
  • Start date Start date
W

William

I have a large database with about 6000 rows. Occasionally, I need to delete
a large number of the rows (5900), and save the remaining data (100 rows) as
a different database. What is annoying in the smaller database, however, is
that the vertical scroll bar still "behaves" as if there were 6000 rows. The
entire 100 row smaller database can be navigated in the top 1/4 inch of the
scroll bar. It makes it very difficult to navigate using the bar. Is there
a way to "reset" what the scroll bar is perceiving as the file size, so that
the bottom of the scroll bar brings me to row 100?

Thanks,
 
Press Alt/F11 (takes you to the VBE)
Press Ctrl/G (immediate window)
type this & press enter, & you'll have the right scrollbar:
Activesheet.Usedrange
 
Press Alt/F11 (takes you to the VBE)
Press Ctrl/G (immediate window)
type this & press enter, & you'll have the right scrollbar:
Activesheet.Usedrange
 
Thanks, everyone!!
--
William


Bob Umlas said:
Press Alt/F11 (takes you to the VBE)
Press Ctrl/G (immediate window)
type this & press enter, & you'll have the right scrollbar:
Activesheet.Usedrange
 
Back
Top