Hello I am trying to create a macro that will run another macro on all tabs EXCEPT the 1st tab named totals (Sheet1) and last tab named Stats (Sheet44). I have no clue how to do this. Here is a macro that will run a macro on ALL tabs but I am not sure how to alter it to make it exclude tabs.
Any help would be greatly appreciated!
Code:
Sub WorksheetLoop2()
' Declare Current as a worksheet object variable.
Dim Current As Worksheet
' Loop through all of the worksheets in the active workbook.
For Each Current In Worksheets
' Insert your code here.
' This line displays the worksheet name in a message box.
MsgBox Current.Name
Next
End Sub
Any help would be greatly appreciated!