Ignore a sheet

[cottage6]

Hi,
If you use "For each wks in ActiveWorkbook. Worksheets", is there a way to
leave out a sheet, for example the Summary Sheet? Or do I need to figure out
another way? Thanks!

 

[Tom Hutchins]

Check the sheet name of wks each time before ding any processing on it:

For Each wks In ActiveWorkbook.Worksheets
If wks.Name <> "Summary" Then
'do something
End If
Next wks

Hope this helps,

Hutch