If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Position screen at end of macro
So far, at the end of a macro I've been sending the cursor across to various
columns and back to position the screen. Itys a bit clumsy, and of course when you work between different sized computer monitors it doesn't work the same. Is there a quick way to position a partcular cell at top left of screen - and perhaps on a separate occasion a particular cell at bottom right? Thanks. |
#2
|
|||
|
|||
Position screen at end of macro
Hi,
To put a cell at the top left Application.Goto ActiveSheet.Range("B3"), scroll:=True -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Kevryl" wrote: So far, at the end of a macro I've been sending the cursor across to various columns and back to position the screen. Itys a bit clumsy, and of course when you work between different sized computer monitors it doesn't work the same. Is there a quick way to position a partcular cell at top left of screen - and perhaps on a separate occasion a particular cell at bottom right? Thanks. |
#3
|
|||
|
|||
Position screen at end of macro
Hi Kevryl
Try the below Sub GoToTopLeft() Dim rngTemp As Range Set rngTemp = Range(Split(ActiveWindow.VisibleRange.Address, ":")(0)) Application.Goto rngTemp, True End Sub Sub GoToBottomRight() Dim rngTemp As Range Set rngTemp = Range(Split(ActiveWindow.VisibleRange.Address, ":")(1)) rngTemp.Offset(-1, -1).Activate End Sub -- Jacob (MVP - Excel) "Kevryl" wrote: So far, at the end of a macro I've been sending the cursor across to various columns and back to position the screen. Itys a bit clumsy, and of course when you work between different sized computer monitors it doesn't work the same. Is there a quick way to position a partcular cell at top left of screen - and perhaps on a separate occasion a particular cell at bottom right? Thanks. |
#4
|
|||
|
|||
Position screen at end of macro
Thanks Mike and Jacob!
"Kevryl" wrote: So far, at the end of a macro I've been sending the cursor across to various columns and back to position the screen. Itys a bit clumsy, and of course when you work between different sized computer monitors it doesn't work the same. Is there a quick way to position a partcular cell at top left of screen - and perhaps on a separate occasion a particular cell at bottom right? Thanks. |
Thread Tools | |
Display Modes | |
|
|