Ignore a sheet
 

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!

Ignore a sheet
 

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

"cottage6" wrote:

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!