Hi,

I would like to write the array set of sheets name below BUT these sheets maybe deleted in the previous macro if it does not meet the criteria.

e.g. lets say, sheets("ScorePerformance_BB") was deleted before, the code may not be able to run.

how to resolve it 
For Each ws In Sheets(Array("ScorePerformance_BB", _
                            "ScorePerformance_RCB", _ 
                            "ScorePerformance_CC", _
                            "ScorePerformance_RFS", _
                            "ScorePerformance_FTG", _
                            "ScorePerformance_MINVT", _
                            "ScorePerformance_CR"))