Is it possible at all to modify a collection of sheets by using the sheet name.
I have a workbook that has about 20 sheets. There are 5 Kinds of sheets in each workbook. ie. 5 Assumption Sheets ("(1) Assump","(2) Assump","(3) Assump"...etc). Each kind is identical to each other.
I would like to know if I can use a wild card to select the group of sheets and edit them. I.e "*Assump" in a macro.