I am using this line of code to loop between specific sheets
For Each WS In Sheets(Array("Sheet1", "Sheet2","Sheet3"))

Problem: instead of Sheet3 , I need to use it's code name Sheet03
I tried For Each WS In Sheets(Array("Sheet1", "Sheet2",Sheet03)) but I got error Type mismatch

CodePudding user response：

Perhaps the following:

For Each WS In Sheets(Array("Sheet1", "Sheet2", Sheet03.Name))