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

Similar Threads

how to place a picture in the upper left corner of the header in 2
scroll so that the upper left cell in a range moves to the upper left of the active window 6
What is small green triangle in upper left corner of cell? 6
Returning Cell to Upper-Left-Most Corner 7
worksheet shifts to upper left hand cornerwhen I am entering data into a cell 1
choosing cell to top left of visible window 3
Keep Consistent cell positions on screen across tabs 6
Determine upper visible corner of sheet 2

Top