Screen Update

[Varne]

Hello

The following code does not always work in an application I developed which
is not so small;

Application.goto cells(1,1),scroll=true

The scrolling does not really take place.

I tried with ActiveWindow.SmallScroll ToLeft:=100 stuff.

If you have faced such a problem before could you please let me know guesses?

Thank You.

 

[Varne]

Hello

Thanks. It is OK now but I explain what happened for someone could find it
useful.

if we use say

ActiveWindow.SmallScroll ToLeft:=100

then VBA gives an error message if there is no cell to the left. However it
does not do so if we use 'LargeScroll' instead of SmallScroll. Therfore we do
not need to worry about what part of the screen we are currently in.

Thank You.