When you use either the
SmallScroll or
LargeScroll methods in a Microsoft Visual Basic for Applications
Sub procedure, you may receive an error message similar to one of the following:
Run-time error '1004':
SmallScroll method of Window class failed
-or-
Run-time error '1004':
LargeScroll method of Window class failed
↑ Back to the top
This error message may occur if a chart sheet is active when your Sub procedure calls either the SmallScroll or LargeScroll method.
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top
In Visual Basic for Applications, you can use the SmallScroll and LargeScroll methods to scroll a worksheet or an Excel macro sheet window. Each method accepts up to four arguments, indicating the number of rows or columns to scroll down, up, right, and left.
↑ Back to the top
For more information about the SmallScroll method, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type SmallScroll Method in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
↑ Back to the top