View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ed ed is offline
external usenet poster
 
Posts: 59
Default Macro code to page down


-----Original Message-----
Ed

Sub Page_Down()

Worksheets("abc").Activate
ActiveWindow.LargeScroll Down:=1

End Sub

Gord Dibben Excel MVP

On Sat, 18 Sep 2004 09:11:15 -0700, "Ed"


wrote:

Worksheets("abc").???????

Can anyone tell me what coding is needed (replacing the ?'s
and/or additional lines needed, if needed) in the above
line to make it page down 1 page on the screen?
(the same result as when you would press "page down" key on
keyboard.)

Or is that impossible to do?
I would like to know either way.
Thankyou
Ed


.
Gord

Thankyou, it works perfect.
Ed