Moving Active Cell to Upper Left Hand Corner of Screen

R

RJB

I want to run a macro that goes to a specific cell - say, GG217.

Here's my code:
Sub GotoGG217
Sheets("Sheet1").Select
Application.Goto Reference:="R217C189"
End Sub

This selects GG217, but sometimes it's on the lower-right hand corner of the
screen, sometimes the upper right, etc. I'd like it in the UPPER LEFT.

How to do? (And since it doesn't seem to be consistent, and different folks
will be running this with different-sized monitors, putting in
"ActiveWindow.SmallScroll" probably won't work...)
 
J

Jim Rech

Application.Goto Reference:="R217C189", Scroll:=True

--
Jim
|I want to run a macro that goes to a specific cell - say, GG217.
|
| Here's my code:
| Sub GotoGG217
| Sheets("Sheet1").Select
| Application.Goto Reference:="R217C189"
| End Sub
|
| This selects GG217, but sometimes it's on the lower-right hand corner of
the
| screen, sometimes the upper right, etc. I'd like it in the UPPER LEFT.
|
| How to do? (And since it doesn't seem to be consistent, and different
folks
| will be running this with different-sized monitors, putting in
| "ActiveWindow.SmallScroll" probably won't work...)
 

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