View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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