I have code that loops through the sheets in my workbook, then the tables on each sheet and takes action on all tables except one. I want to add a bunch of new tables which will require a different action. Roughly, my code now is:
Code
For Each oSh In ActiveWorkbook.Sheets
For Each tbl In oSh.ListObjects
If tbl.Name <> "TableCalcs" Then
Do something
End If
Next tbl
Next oSh
What I would like to do is replace the for each table line with something like For Each tbl in A TABLE ARRAY OR LIST (table1, table 4, table 5). Is this possible or should I use a select case construction?
TIA