automated scrolling

[macro_panic]

is there a way of slowly and smoothly scrolling down the screen in a macro please? i want to put some code in my auto_open macro which initially displays cell A1 at the top left of the screen for a couple of seconds then smoothly scrolls down to displaying A30 at the top left. any ideas? (hope this is clear)

as you can probably tell, i am already in an august bank holiday mood...

thanks in advance
m_p

 

[applebyd]

The easiest way to do it would be to
use a scrolling wheel on a mouse during
the Macro recording.

Leastways that's what I do.

HTH

DaveA

 

[macro_panic]

good point, but that would scroll in increments of one cell height and i was really looking for a smoother scroll - like a nice bit of flash!!!

 

[applebyd]

OK OK.

Try using
Application.screenupdating = False

and

Application.Screenupdating = True

Between the scroll.

Whilst this won't give you a smooth scroll it will just give one jump. Also if you bind the whole macro it should speed up the running.

Apologies if It's preaching and converted.

DaveA

:wink:

 

[Legacy 98055]

Excel will scroll no less than one cell at a time. The only way I know to "smooth" it out would be to choose many rows, change the row height to a small valueof about 1 pixel or .75, use the smallscroll method.
Ex.
<pre>
Sub ScrollNow()
For x = 1 To 2000
ActiveWindow.SmallScroll Down:=1
Next
End Sub

</pre>
Merge cells to display text large enough to view. I'll mail you an example book.
Tom