Microsoft KB Archive/213662

= XL2000: Macro Cannot Scroll Chart Sheet =

Article ID: 213662

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213662





SYMPTOMS
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



CAUSE
This error message may occur if a chart sheet is active when your Sub procedure calls either the SmallScroll or LargeScroll method.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
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.

