scroll so that the upper left cell in a range moves to the upper left of the active window

[Andre]

I have single cells that have range names. Simple selection macros select
it. problem is that it is not displayed in the upper left corner of the
window, I have to manually scroll to show the cells below the named cell. I
know it's simple but I can't locate any reference to it in the books I have.
any help would be appreciated, thanks

 

[Rick Rothstein]

If you don't have to show it in the upper left corner of the window, then
just execute the Show method for it... that will make it appear at the
bottom of the window. For example,

Range("F150").Value = "XXX"
Range("F150").Show

 

[Mike H]

To show it in the top left corner

Application.Goto ActiveCell, Scroll:=True

Mike

 

[Rick Rothstein]

Thanks Mike... I just learned something new.

 

[JLGWhiz]

In addition to Mike's suggestion, If you want to specify other than the
active sheet or active cell, this is the full syntax.

Sub Scrl()
Application.Goto Reference:=Worksheets("Sheet3").Range("T120"), _
Scroll:=True
End Sub

 

[Mike H]

I'm; how shall we we say, a septugenarian and I hope there never comes a day
when I don't learn something new but I'm comforted in the knowledge I'm a
very long way from that point at the moment

 

[JLGWhiz]

Right Mike, at our age we welcome the opportunity to learn. Remembering is
the problem.