![]() |
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 |
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