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

hi
i suspect that excel as lost it's used range reference.
see this site for a fix.
http://www.contextures.com/xlfaqApp.html#Unused

regards
FSt1

"William" wrote:

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

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

"William" wrote:

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

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

"William" wrote:

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

Thanks, everyone!!
--
William


"Bob Umlas, Excel MVP" wrote:

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

"William" wrote:

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