Macro code to page down

[Ed]

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 Dibben]

Ed

Sub Page_Down()

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

End Sub

Gord Dibben Excel MVP

 

[Ed]

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

Sub Page_Down()

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

End Sub

Gord Dibben Excel MVP



.
Gord

Thankyou, it works perfect.
Ed