View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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