SmallScroll error in macro
 

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

SmallScroll error in macro
 

Hi PBM,

Try:

ActiveWindow.SmallScroll Down:=5

---
Regards,
Norman



"PBM" wrote in message
...

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

SmallScroll error in macro
 

Try this:


Code:
--------------------
ActiveWindow.SmallScroll Down:=5
--------------------

HTH
ilyaskazi


--
ilyaskazi
------------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...o&userid=23969
View this thread: http://www.excelforum.com/showthread...hreadid=486476

SmallScroll error in macro
 

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

ActiveWindow.SmallScroll Down:=5

--
Cheers
Nigel



"PBM" wrote in message
...

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

SmallScroll error in macro
 

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


--
PBM
------------------------------------------------------------------------
PBM's Profile: http://www.excelforum.com/member.php...o&userid=28900
View this thread: http://www.excelforum.com/showthread...hreadid=486476