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.

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.