Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Application.Goto reference:="MyCell"

If I have a named range called MyCell, and I go there with Application.Goto
reference:="MyCell", I would like to have the Sheet scroll this range to the
top of the Window.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default Application.Goto reference:="MyCell"

You can probably calculate how to scroll the window based on the location of
the upper-left cell of "MyCell", but I did it by:

ActiveCell.SpecialCells(xlLastCell).Select
Selection.End(xlDown).Select
Selection.End(xlToRight).Select
Application.Goto "MyCell"


"akyhne" wrote:

If I have a named range called MyCell, and I go there with Application.Goto
reference:="MyCell", I would like to have the Sheet scroll this range to the
top of the Window.

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
HOW IS COLUMN "K" REFERENCED ON THE CURRENT ROW IN THE GOTO COMMAN mbnspect Excel Discussion (Misc queries) 5 January 10th 08 11:50 PM
Custom Data Validation : Lock if MyCell = ""? RayportingMonkey Excel Worksheet Functions 5 October 25th 07 03:14 PM
Excel VBA - go to worksheet "name" based on a cell reference ="Name" james007 Excel Programming 2 July 8th 04 11:04 PM
'Application.Goto Reference Tom Ogilvy Excel Programming 0 February 24th 04 06:15 PM


All times are GMT +1. The time now is 03:09 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"