Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 JJ mac Setting up and Configuration of Excel 7 June 14th 07 06:54 PM
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word urbanplanner Excel Discussion (Misc queries) 3 December 7th 05 03:57 PM
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet Graham Jones Excel Discussion (Misc queries) 1 May 13th 05 12:58 AM
How do i create a command button or macro to exit Microsoft Excel raj Excel Worksheet Functions 1 April 30th 05 02:17 PM
Eliminate screen flashing while running a macro using VBA in Microsoft Excel. abbeville Excel Programming 1 May 21st 04 02:11 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"