Screen Update

V

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.
 
T

The Code Cage Team

This ActiveWindow.SmallScroll ToLeft:=100 works for me however if yo
dont have 100 cells to the left of the current cell then it will no
happen

--
The Code Cage Tea

Regards,
The Code Cage Team
http://www.thecodecage.co
 
V

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