Change scroll bar to end at end of text not bottom of worksheet??
 

When I pull the scroll bar to the bottom it ends on about line 16000, but my
text stops at 1600, and that is where I am trying to stop at.
I works correctly in some pages of the same work book but not on others.

How can I adjust this

Change scroll bar to end at end of text not bottom of worksheet??
 

Hi!

Try resetting the used range:

http://contextures.com/xlfaqApp.html#Unused

Do this for each sheet. If this was in fact the problem this procedure will
also reduce the size of the file.

Biff

"Garfield" wrote in message
...
When I pull the scroll bar to the bottom it ends on about line 16000, but
my
text stops at 1600, and that is where I am trying to stop at.
I works correctly in some pages of the same work book but not on others.

How can I adjust this

Change scroll bar to end at end of text not bottom of worksheet??
 

Garfield

Check out the info and fixes for this at Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Mon, 5 Jun 2006 11:03:02 -0700, Garfield
wrote:

When I pull the scroll bar to the bottom it ends on about line 16000, but my
text stops at 1600, and that is where I am trying to stop at.
I works correctly in some pages of the same work book but not on others.

How can I adjust this