ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Microsoft Excel Macro (https://www.excelbanter.com/excel-programming/310235-microsoft-excel-macro.html)

Ed Nielsen

Microsoft Excel Macro
 
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

R.VENKATARAMAN

Microsoft Excel Macro
 


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





All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com