Debra,
Thanks! Worked like a charm!
Shane
-----Original Message-----
There are instructions here for manually or
programmatically resetting
the used range:

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

Shane wrote:
Greetings,
A bunch of us are re-introducing ourselves to Excel
2000
at work and so far doing alright. We have noticed,
however, that while we're editing worksheets we'll
suddenly find that our LARGE/LONG scroll bar (sometimes
vertical, sometimes horizontal, sometimes both) has
shrunk
to miniature size and suddenly our worksheet has a
gozillion rows and columns.

We're not concerned about printing, as we all know how
to
use View\Page Break Preview, but it's awfully annoying
to
try to navigate with a miniature scroll-bar and only a
viewable 1.5 pages of worksheet. We should have a
scrollbar that covers about 75% and go from there, but
for
some reason it covers about 5%.

Sooo.. any ideas how to either prevent that
(preferable)
or at least get RID of them?

Highligting a row, then hitting Ctrl + End just
highlights
a single cell way down and over.. so we can't just do
that and delete the extra rows and columns.

Any help is appreciated!
Shane


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.