rjwebgraphix
Well-known Member
- Joined
- May 25, 2010
- Messages
- 590
I'm just looking for a suggestion to get me started. I'm looking to loop through 11 different worksheets, but not all worksheets in the workbook.
In the VBA editor they read like this...
Sheet14 (E00)
Sheet22 (PR)
Sheet23 (W10)
Sheet24 (E02)
Sheet25 (E03)
Sheet26 (E04)
Sheet27 (E14)
Sheet28 (P03)
Sheet29 (P05)
Sheet30 (W02)
Sheet31 (W08)
There are sheets in between 14 and 22 that I don't want to loop through. This is also not the order I'd prefer to loop through them. I'd prefer to loop them in the order they are in the workbook which is:
PR, E00, E02, E04, E14, P03, P05, W02, W08, W10
Is there an easy way to just say loop through them in order from PR to W10? I was thinking of just doing an array with them in that order and loop through the array, but I'm not the greatest with array's and rather avoid that route if there's a better way. I've found many articles are looping through all WS's, but haven't found one yet for a specific set of WS.
Thanks,
RJ
In the VBA editor they read like this...
Sheet14 (E00)
Sheet22 (PR)
Sheet23 (W10)
Sheet24 (E02)
Sheet25 (E03)
Sheet26 (E04)
Sheet27 (E14)
Sheet28 (P03)
Sheet29 (P05)
Sheet30 (W02)
Sheet31 (W08)
There are sheets in between 14 and 22 that I don't want to loop through. This is also not the order I'd prefer to loop through them. I'd prefer to loop them in the order they are in the workbook which is:
PR, E00, E02, E04, E14, P03, P05, W02, W08, W10
Is there an easy way to just say loop through them in order from PR to W10? I was thinking of just doing an array with them in that order and loop through the array, but I'm not the greatest with array's and rather avoid that route if there's a better way. I've found many articles are looping through all WS's, but haven't found one yet for a specific set of WS.
Thanks,
RJ