Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to return to worksheet where macro started?
I have a macro that turns off screen updating and then proceeds to jump
around to different worksheets to copy/paste/change some cells. At the end of this macro process, before I turn screen updating back on, I want to return to the cell/worksheet that I was on when I started started the macro running. This is not always the same cell/worksheet and I can't seem to find how one would do this. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to return to worksheet where macro started?
Hello
If I inderstande your question : Before the traitement you declare an objet range MyRange = activesheet.select And, after the traitement you reposituonne the selection MyRange.parent.parent.activate MyRange.parent.select MyRange.select or, something almost J a c q u e s "Bob Arnett" a écrit dans le message de ... I have a macro that turns off screen updating and then proceeds to jump around to different worksheets to copy/paste/change some cells. At the end of this macro process, before I turn screen updating back on, I want to return to the cell/worksheet that I was on when I started started the macro running. This is not always the same cell/worksheet and I can't seem to find how one would do this. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to return to worksheet where macro started?
My suggestion is to not jump all around in the first place. It is almost
never required to select worksheets and cells to affect changes to them via VBA. However, you did not post your code so it is a little hard for any of us to show you how to avoid it in your particular situation. Rick "Bob Arnett" wrote in message ... I have a macro that turns off screen updating and then proceeds to jump around to different worksheets to copy/paste/change some cells. At the end of this macro process, before I turn screen updating back on, I want to return to the cell/worksheet that I was on when I started started the macro running. This is not always the same cell/worksheet and I can't seem to find how one would do this. Any suggestions? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to return to worksheet where macro started?
Hi Bob,
As already indicated by Rick, it is rarely necessary, or efficient to select objects; normally it is preferable to manipulate relevant object variables. That said, one approach might be: '========= Public Sub Tester() Dim rngOriginal As Range Dim rCellOriginal As Range Set rngOriginal = Selection Set rCellOriginal = ActiveCell ' Your code Application.Goto rngOriginal rCellOriginal.Activate End Sub '<<========= --- Regards. Norman "Bob Arnett" wrote in message ... I have a macro that turns off screen updating and then proceeds to jump around to different worksheets to copy/paste/change some cells. At the end of this macro process, before I turn screen updating back on, I want to return to the cell/worksheet that I was on when I started started the macro running. This is not always the same cell/worksheet and I can't seem to find how one would do this. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get Started with macro? | Excel Discussion (Misc queries) | |||
Relative return to original worksheet in middle of macro | Excel Programming | |||
Personal macro file will not pull up when excel is started | Setting up and Configuration of Excel | |||
The myworkbook.xls Auto_Open() macro won't run if started by a VBS | Excel Programming | |||
Macro to return to previous worksheet | Excel Programming |