Multiple worksheet options

[Pablo_TX]

I have a macro that is current set to look for a specific worksheet, Sheets("Prog Off Core"). I was just told that there could be a few variations of Prog Off.

Prog Off Core Print
Prog Off Resource Print
Prog Off Core Digital
Prog Off Resource Digital

Thank you.

Please Login or Register  to view this content.

[Norie]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[leelnich]

Hi Pablo - Assuming there's only ONE "Prog Off " sheet in the active workbook, give this a try:
Code Updated 12:31 pm

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[leelnich]

By the way, I didn't change it, but I'm fairly certain you don't need to loop to insert the formula. This does the same thing:

Please Login or Register  to view this content.

[Pablo_TX]

Thank you!

[leelnich]

Happy to help! If you have your answer, please got to Thread Tools just above your ORIGINAL POST and mark your thread as SOLVED. Thanks!-Lee

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee