scrollbar with huge range

  • Thread starter Thread starter daMike
  • Start date Start date
D

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
 
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.
 
Back
Top