Your welcome. Yes, it can be written in other ways. I suppose you are just asking for learning purposes!



You can do a google search for "for each ws in array" and see different options.

There are many factors that go into deciding what to use. How many sheets are there? If only one or two other sheets besides the "130R", "135R", "140R", you could use an if statement construct.

You could also use a case statement. Maybe even Lbound/Ubound structure.

Many different ways to skin this cat.