RV6555
09-06-2007, 03:21 AM
I need to do several activities on all worksheets in a workbook, except for sheet1.
The code so far is as follows:
Sub PerformActivities ()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
?I deleted the copy/pasting code here in order to decrease the length of this post
Next ws
End Sub
What happens is that information from several worksheets is collected and copied to sheet1. Therefore the process should not collect information from sheet1 in order not to mess up that sheet. Now I am trying to figure out how to make it look through all worksheets except sheet1 (this is also the name of the sheet). Any suggestions?
The code so far is as follows:
Sub PerformActivities ()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
?I deleted the copy/pasting code here in order to decrease the length of this post
Next ws
End Sub
What happens is that information from several worksheets is collected and copied to sheet1. Therefore the process should not collect information from sheet1 in order not to mess up that sheet. Now I am trying to figure out how to make it look through all worksheets except sheet1 (this is also the name of the sheet). Any suggestions?