View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Macro code to page down

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