Select All Sheets

[Pestomania]

Hi, I am trying to select all sheets with the name assembly. What happens is it selects all sheets with the name Assembly, assembly (2), assembly (3), etc. Then it adds a color to range T13:U21 based on the value in another sheet. But Everytime I try a different code, it only applies to the last "assembly" sheet in the workbook. Can someone please help?

 

[jim may]

Best/More Helpful to us if you post your Existing Code also

 

[Pestomania]

Best/More Helpful to us if you post your Existing Code also

Hi, well I finally realized I was having it format after it ran the sheet selection script. Once I realized that I called for the macro that formatted inside of the selection script which allowed it to go sheet by sheet and format each one. Now it works amazingly. Sorry for any confusion.