scrollbar with huge range

[daMike]

Hello,

I have a sheet where I use at least the first
300 rows, but the scrollbar span an area of something
around 60000 rows. I tried the following command:

Worksheets(1).ScrollArea = "A1:IV500"

but it does not shrink the scrollbar to a reasonable
range. What it does is

1. Only the range A1:IV300 can be modified!

2. The scrollarea span an area of A1:IV60000 altought
there are no data in the cells!

Hope somebody can help me!

Thanks in advance!
Michael

 

[Earl Kiosterud]

Mike,

Try this:

Select all the rows following your last data rowTo do this, select the first
unused row (click in the row header), press Ctrl-Shift-down.

Now delete them (Edit - Delete or Ctrl-Minus. Not just the Delete key).

Save the file. Maybe close and reopen if necessary.