Specific sheet name macro help

Hey all,

I am looking for help with a VBA code. I want to the script to run through the work book and only perform clearing out certain cells on specifically named sheets and to continue to execute the rest of the functions if that sheet doesn't exist. The problem I am running into is sometimes these reports do not have all the sheets (some are not needed). For example I have 6 sheets in a template that I need to account for (among many other sheets). So say I have sheets named PS1, PS2, PS3, PS4, PS5, and PS6. Most of the time these reports only contain PS1 and PS2, but I need it to check for all and not return an error if they do not exist. I will supply what I have so far. The problem lies inbetween ' Power Supply Clear and ' First Few Page Clear. All the rest works as intended. Thanks in advance!

Please Login or Register  to view this content.

Forgive my VBA ignorance, but am I to insert all of that code in between like so? I am including my entire macro as maybe this will shed some light. I receive a compile error expected end sub.

Please Login or Register  to view this content.

The Array portion is working perfectly in the top section. Its somewhat complicated what that code is doing. Is there just a way to execute what I am looking for with also keeping the top portion?

Maybe explain in a short but sweet manner what you want to accomplish. Be concise.
All the "Selecting" in your code only slows down execution time and is not required.

OK, I got all of it working now. Thanks guys for your help!