Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add Second Page to Code | Excel Discussion (Misc queries) | |||
Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
page setup via code | Excel Programming | |||
Vb code to print a page # | Excel Programming | |||
Code to get hyperlinks from open web page. | Excel Programming |