View Single Post
 
Old 09-24-2018, 11:42 AM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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.
Reply With Quote