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

---
Regards,
Norman



"PBM" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> PBM
> ------------------------------------------------------------------------
> PBM's Profile:
> http://www.excelforum.com/member.php...o&userid=28900
> View this thread: http://www.excelforum.com/showthread...hreadid=486476
>

[ilyaskazi]

Try this:

Please Login or Register  to view this content.

HTH
ilyaskazi

[Nigel]

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

ActiveWindow.SmallScroll Down:=5

--
Cheers
Nigel



"PBM" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
>
> --
> PBM
> ------------------------------------------------------------------------
> PBM's Profile:
http://www.excelforum.com/member.php...o&userid=28900
> View this thread: http://www.excelforum.com/showthread...hreadid=486476
>

[PBM]

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