SCROLL AREA

[verluc]

I have i n "This workbook" and in "Sheets1" the following line:
.scrollarea = ("A5:L" & Range("L65536").End(xlUp).Row)

The problem is that I can scroll with the arrow down,to the last line,but with the mousewheel I can scroll only to line 101 and further I must go with the down arrow.
Why I can't scroll with the mousewheel to the last line?
Many thanks in advance.

 

[Mudface]

Presumably because the mousewheel scrolls more than one line at a time and would exceed the limits of your scroll area.

 

[verluc]

O.K. that can be the reason.Thanks for your response.