Macro code to page down
 

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

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

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