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
|