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

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

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

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

--
Rick (MVP - Excel)


"Andre" wrote in message
...
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

scroll so that the upper left cell in a range moves to the upper l
 

To show it in the top left corner

Application.Goto ActiveCell, Scroll:=True

Mike

"Andre" wrote:

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

scroll so that the upper left cell in a range moves to the upper l
 

Thanks Mike... I just learned something new.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
To show it in the top left corner

Application.Goto ActiveCell, Scroll:=True

Mike

"Andre" wrote:

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

scroll so that the upper left cell in a range moves to the upper l
 

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

"Andre" wrote:

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

scroll so that the upper left cell in a range moves to the upp
 

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

"Rick Rothstein" wrote:

Thanks Mike... I just learned something new.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
To show it in the top left corner

Application.Goto ActiveCell, Scroll:=True

Mike

"Andre" wrote:

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

scroll so that the upper left cell in a range moves to the upp
 

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

"Mike H" wrote:

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

"Rick Rothstein" wrote:

Thanks Mike... I just learned something new.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
To show it in the top left corner

Application.Goto ActiveCell, Scroll:=True

Mike

"Andre" wrote:

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