Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In my macro, I enter many figures in cells on the screen.
All the spreadsheet cells that I use are not on the screen at the same time. When the entering of figures goes off the bottom of the screen, I want the macro to automatically scroll down (or page down) to keep the entering activity on the screen. Can a Macro be written to automatically scroll down or page down? If it can, how do you do it? Ed Nielsen |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() did you try <edit-goto. will this server your purpose. you can even use <special in the left bottom of <goto window. Ed Nielsen wrote in message ... In my macro, I enter many figures in cells on the screen. All the spreadsheet cells that I use are not on the screen at the same time. When the entering of figures goes off the bottom of the screen, I want the macro to automatically scroll down (or page down) to keep the entering activity on the screen. Can a Macro be written to automatically scroll down or page down? If it can, how do you do it? Ed Nielsen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
How do i create a command button or macro to exit Microsoft Excel | Excel Worksheet Functions | |||
Eliminate screen flashing while running a macro using VBA in Microsoft Excel. | Excel Programming |