Perform same task to multiple worksheets that contain a text parameter

[shawnvon]

Hello,
I am trying to do the following: I want to replace the values in A1:A3 with "0" and clear the contents of B1:B3 for all worksheets that contain "ILA" in the worksheet name. Is there a simple way to do this or another thread that already answers this question? I tried to search on the internet but found nothing useful. Here is a sample file (NOTE: there are no macros in this workbook even though it is saved as an .xlsm).

Clear and replace macro on multiple tabs.xlsm

Thanks in advance.

[fredlo2010]

See if this helps

Please Login or Register  to view this content.

Thanks

[shawnvon]

Thanks for the quick reply fredlo2010. It did not work. It deleted and replace with zero cells A4 and B4 as well. I only need to change A1:A3 to zero and B1:B3 to be cleared. The rest of the cells in the worksheet should stay the same. The macro also affected the sheet with "OLA" in the title. It should only affect worksheets whose name contains "ILA".

[fredlo2010]

I fixed the range. Are you sure about OLA? I tested it and it works fine for me. Can you post a sample of the workbook. My code will change sheet that has a name ending in "ILA"

Please Login or Register  to view this content.

Thanks

[shawnvon]

Works like a champ now. Thanks so much!!!!!!!!!!!!

[fredlo2010]

you are welcome I am glad I was able to help. If you have to change a lot of sheets use this. The screen will not even blink.

Please Login or Register  to view this content.

If my answer was helpful don't forget to help my reputation