Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating the last active worksheet
I hope someone can help me with the following:
I have a macro that needs to jump between two worksheets. If I'm currently in let's say Sheet "A", and then I activate Sheet "B", what code could I use to return/reactivate the "last" active worksheet (in this example, go back to Sheet "A")? (I can not use any sheet name since this will always be different; also, I can't depend on the position or order of the worksheets). In other words, I need the code that will take me from my current worksheet to the worksheet that was active just prior to the sheet where I am now... Thanks for any help!! -- Chris M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating the last active worksheet
Hi Chris
ActiveWindow.ActivateNext Brings me back to the last window I was in "Chris M" wrote: I hope someone can help me with the following: I have a macro that needs to jump between two worksheets. If I'm currently in let's say Sheet "A", and then I activate Sheet "B", what code could I use to return/reactivate the "last" active worksheet (in this example, go back to Sheet "A")? (I can not use any sheet name since this will always be different; also, I can't depend on the position or order of the worksheets). In other words, I need the code that will take me from my current worksheet to the worksheet that was active just prior to the sheet where I am now... Thanks for any help!! -- Chris M |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activating the last active worksheet
Hi Chris,
You could assign the initial worksheet to an object variable and use the variable to return to the sheet. Something like: Sub Tester Dim WS as Worksheet Set WS = ActiveSheet ' your code to activate another worksheet ' your futher processing code WS.activate '<<===== Return to base! End sub However, vastly perferable would be not to activate various sheets or make selections. For example, instead of: '--------------------- Worksheets(2).Activate Range("A1"").Select ActiveCell.Value = 5 Worksheets(4).Activate Range("D10"").Select ActiveCell.Value = 50 etc. '----------------------- Equivalent non selection / non activation code might be: Worksheets(2).Range("A1"").Value=5 Worksheets(4).Range("D10"").Value=50 Not only is the latter code shorter, easier to maintain and faster, but there is a reduced processing overhead and you avoid the problem of loosiing your way - the subject of your post! --- Regards, Norman "Chris M" wrote in message ... I hope someone can help me with the following: I have a macro that needs to jump between two worksheets. If I'm currently in let's say Sheet "A", and then I activate Sheet "B", what code could I use to return/reactivate the "last" active worksheet (in this example, go back to Sheet "A")? (I can not use any sheet name since this will always be different; also, I can't depend on the position or order of the worksheets). In other words, I need the code that will take me from my current worksheet to the worksheet that was active just prior to the sheet where I am now... Thanks for any help!! -- Chris M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Worksheet? | Excel Discussion (Misc queries) | |||
activating correct worksheet | Excel Programming | |||
Worksheet activating | Excel Programming | |||
Worksheet activating | Excel Programming | |||
Activating a worksheet | Excel Programming |