Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Active Cell to Upper Left Hand Corner of Screen
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...) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Active Cell to Upper Left Hand Corner of Screen
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...) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Active Cell to Upper Left Hand Corner of Screen
Wow. Simple.
Thank you. "Jim Rech" wrote: 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...) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to cell and have it appear at top upper left hand corner | New Users to Excel | |||
How to make a cell appear in upper left (top left) corner of works | Excel Programming | |||
Scroll a cell to the top left hand corner of the screen | Excel Discussion (Misc queries) | |||
What does a small green triangle in the upper left hand corner of. | Excel Discussion (Misc queries) | |||
Moving the Active cell to the left of the screen | Excel Programming |