Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recalling a previously active worksheet
I have a workbook with about 90 worksheets each with a different number as
the sheet name. They are named when created using a customer number. I work with a sheet (the Active Sheet) and then when done have a macro go to an index sheet which lists all the sheets. Sometimes I need to make a change to the last transaction. What I want to do is to have a macro that would go to the last active worksheet (named as a customer number).. for instance 1847). I can write the macro to make the changes I want but don't know how to refer to the last sheet that was active. I can't use it's number because it's constantly changing. How can I store and recall the last shet that was used before I went back to the index sheet? Thanks in advance for the assistance. Jonco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a portion AS WELL AS it's formulas, then recalling | Excel Worksheet Functions | |||
Recalling an array of data | Excel Discussion (Misc queries) | |||
Help with sebastienm's code - Returning To Previously Selected Worksheet | Excel Programming | |||
I need help with recalling information | Excel Discussion (Misc queries) | |||
Selecting Previously Active Cell | Excel Programming |