Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
navigation and re-centering the window
This should be easy for somebody here ... I just can't remember I have code written to go to various cell locations on a worksheet. What is the code to have each of these cell locations to show up on the top of the page? For example, if I'm on cell A1 and then direct it to go to cell Z200, I don't want Z200 to show up in the middle of the screen and then the user has to scroll up to move it to the top of the page. -- gonger ------------------------------------------------------------------------ gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797 View this thread: http://www.excelforum.com/showthread...hreadid=545916 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
navigation and re-centering the window
ActiveWindow.ScrollColumn = range("z200").column ActiveWindow.ScrollRow = range("z200").row Col -- colofnature ------------------------------------------------------------------------ colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356 View this thread: http://www.excelforum.com/showthread...hreadid=545916 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
navigation and re-centering the window
outstanding! works just fine. Thanks, col. -- gonger ------------------------------------------------------------------------ gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797 View this thread: http://www.excelforum.com/showthread...hreadid=545916 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consider space in centering | Excel Discussion (Misc queries) | |||
Centering | New Users to Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
centering items | Excel Worksheet Functions | |||
Centering comments | Excel Worksheet Functions |