SmallScroll error in macro

[PBM]

Am completely new to macros in excel. Can anyone tell me why I am
getting this error message "object doesn't support this property or
method (ERROR 438) on the following code line -"
ActiveSheet.SmallScroll Down:=5 " I have been searching for hours and
can't find a solution

 

[Norman Jones]

Hi PBM,

Try:

ActiveWindow.SmallScroll Down:=5

 

[ilyaskazi]

Try this:


Code:

 

[Nigel]

Use.....but select activate the sheet first

ActiveWindow.SmallScroll Down:=5

 

[PBM]

Norman, Ilyaskai, Nigel,
Thanks guys, it works a treat.