Sheets array code only edits one sheet. Please help

I know there has to be a simple resolution to my problem. Right now I am having to use a chunk of my code multiple times in my macro in order for it to edit all the sheets I need it to edit. I know there has to be a way to get it to work on the sheet array but I have yet to figure it out. I have the sheet array in the code with .select before the editing code but it still does not work. This is just a small portion of my code. Thanks in advance!

Please Login or Register  to view this content.

Try it:

Please Login or Register  to view this content.

Looks like that code is running 4 times on the first sheet.

O! It's my mistake.

Please Login or Register  to view this content.

That worked perfectly! Later in the code I have this section and I tried using the above code for it to but I do not know how to do the section that already had withs. Can you help one more time?

Please Login or Register  to view this content.

Still need help with this part please :
That worked perfectly! Later in the code I have this section and I tried using the above code for it to but I do not know how to do the section that already had withs. Can you help one more time?

Please Login or Register  to view this content.

need it to work in array

Please Login or Register  to view this content.

All you need are 2 dots.

One before Range("A:Q") and one before Range("A1:B1,A3:Q3").