MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Scrolling


Posted by Rick on February 07, 2002 8:45 AM

Is there a way to grab the scroll bar and continuously scroll down (so you can see the cell information as it goes by)instead of jumping from row to row?


Posted by Derek on February 10, 2002 5:20 AM

Yes, do just that. Use your mouse to left click on the slide between the 2 arrows in your scroll bar. Keep you left finger down and move the slide up and down.
If your trying to do this by macro this is a snippet of code but it may scroll too fast for you and I could't work out exactly how to express less than 1 second.
Count = 1
Do Until Count = 200
ActiveWindow.SmallScroll Down:=1
Application.Wait Now + (TimeValue("00:00:01") * 0.25)
Count = Count + 1
Loop
End Sub
Hope this helps
Derek