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
|