Screen Update
 

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.

Screen Update
 

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


--
The Code Cage Team

Regards,
The Code Cage Team
http://www.thecodecage.com
------------------------------------------------------------------------
The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=27920

Screen Update
 

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.


"Varne" wrote:

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.