I'm sure there's an easy solution for this, but I can't think of one. I want this macro to run 3 times on 3 different sheets. The second time it would substitute sheets("HAFA QA1") with ("HAFA QA2") and then ("COOP QA1") the third round. Everything else should stay the same. I just wrote the code out 3 times to get the job done at work, but this seems like a sloppy fix. Any ideas?
Please Login or Register to view this content.
Hi,
Probably something like the following
Please Login or Register to view this content.
Last edited by Richard Buttrey; 12-05-2012 at 06:28 PM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You can create an array of the sheet names, then wrap your loop inside a loop through your new array:
... or...Please Login or Register to view this content.
Loop through every sheet in workbook and only operate on the ones with the right names:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks