JoeFoot,

Thank you for the code, I think I'm close but it's still only running the macro in the sheet i'm currently in. How can I run the macro in every sheet except the sheet named "Tested Party"?