Run Loop on the sheets other than mentioned

Hi suresh7860,

tmp = Array("Summary", "Not Certified", "STAT Reconciliations", "Blank Account#", "Blank Description", "Blank Line#", "Blank Reference", "Prepd Rec's-Unidentified Bal>1", "Preparere Unassigned", "Approver Unassigned", "Reviewer Unassigned", "Acct Reviewer Unassigned", "Acct Owner Unassigned", "Key should be Non-Key", "Non-Key should be Key", "Blank Risk Rating", "Timelines", "Recon WorkFlow")

If W.Name = WorksheetFunction.VLookup(W.Name, tmp, 1, 0) Then 

do something

else

With w
My code
End WITH

end if

next