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!
|