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

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

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

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

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

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

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