Scroll through sheets (except 1st) and ClearContents based on Cell Color

[ksayet]

Hi!


I have a workbook with 16 sheets. The only inputs in the workbook are made in cells colored ColorIndex = 20. I'd like to have a macro that can Clear.Contents of every cell colored "20" throughout the entire workbook excluding the first sheet ("MASTER"). The colored selects are sprinkled inside ("A1:J53") but I'd rather not select them if it's not necessary.

Here's what I have so far...

Please Login or Register  to view this content.

[GC Excel]

Hello,

Here's a slightly modified version of your code to try :

Please Login or Register  to view this content.

[ksayet]

Amazing!! Thanks GC Excel.

[ksayet]

All of my sheets are protected... I have the following subs to unprotect and protect. How can I implement those two into the loop you made me so that I unprotect --- run loop --- protect?

Please Login or Register  to view this content.

Please Login or Register  to view this content.