I am using the following code to exclude a macro from running on some sheets. Is it possible to reference the sheet names from range M2:down for the ones I want to exclude. This way if I add a sheet and I don't want the code to run on it I can just type the name in the range.
Thank you for your time ane help.
Sub Format()
Dim wrkSheet As Worksheet
For Each wrkSheet In ThisWorkbook.Sheets
Select Case wrkSheet.Name Case "Control", "Approved", "PivotApproved", "Title", "TableCont", "Index", "End", "SumType", "PivotType", "CBComp", "New", "Old"
' do nothing
Case Else
With wrkSheet
'code here
Bookmarks