Microsoft KB Archive/191154

= XL98: Macro Cannot Scroll Chart Sheet =

Article ID: 191154

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q191154





SYMPTOMS
When you use either the SmallScroll or LargeScroll methods, you may receive an error message similar to the following:

Run-time error '1004':

SmallScroll method of Window class failed.



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



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.



MORE INFORMATION
In Visual Basic for Applications, you can use the SmallScroll and LargeScroll methods to scroll a worksheet or a Microsoft Excel 4.0 macro sheet window. Each method accepts up to four arguments, indicating the number of rows or columns to scroll down, up, right, and left.

