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

A

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
 
R

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
 
J

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
 
M

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 :)
 
J

JLGWhiz

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top