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

--
Jim
"RJB" wrote in message
...
|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...)