Thread: Moving active window to selected range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
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
Reply With QuoteReply With Quote