Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Moving active window to selected range


Excel version: 11 (2003 SP2)
OS: WXP SP2

My code has moved the cursor to an offscreen location in the activ
window. How do I move (scroll?) the window view to display that rang
in the upper left corner of the window?

- A

--
GoFigur
-----------------------------------------------------------------------
GoFigure's Profile: http://www.excelforum.com/member.php...nfo&userid=427
View this thread: http://www.excelforum.com/showthread.php?threadid=49105

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Moving active window to selected range

application.goto activecell, scroll:=true

is one way.

GoFigure wrote:

Excel version: 11 (2003 SP2)
OS: WXP SP2

My code has moved the cursor to an offscreen location in the active
window. How do I move (scroll?) the window view to display that range
in the upper left corner of the window?

- Al

--
GoFigure
------------------------------------------------------------------------
GoFigure's Profile: http://www.excelforum.com/member.php...fo&userid=4274
View this thread: http://www.excelforum.com/showthread...hreadid=491050


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Moving active window view to selected range


Dave, thanks for taking the time to reply. Perfect

--
GoFigur
-----------------------------------------------------------------------
GoFigure's Profile: http://www.excelforum.com/member.php...nfo&userid=427
View this thread: http://www.excelforum.com/showthread.php?threadid=49105

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
Arrow Keys Moving Window Frame instead of Moving Between Cells nemmex Excel Discussion (Misc queries) 2 April 9th 07 09:08 AM
Moving to next row below a selected range Loris Excel Programming 6 December 5th 05 03:47 AM
active window Gerry Excel Programming 2 December 17th 04 03:33 PM
Moving between a cell that is selected to include a range of cells in that row kls[_2_] Excel Programming 0 September 30th 04 12:14 AM
Open a window / box showing a selected range of cells only jennie Excel Programming 2 April 30th 04 02:32 PM


All times are GMT +1. The time now is 01:55 AM.

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"