VBA : Modifying Multiple Sheets using Sheet names

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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.


  • I'm sure that there is a better way than performing the modifications 1 page at a time. So be on the lookout for a better solution.

    However, until then here is a solution which you can use which will find the all the pages in the workbook which have the desired string in the page name

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!