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
|