SCROLL BAR ISSUE

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,
 
B

Bob Umlas, Excel MVP

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
 
B

Bob Umlas, Excel MVP

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
 
W

William

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top