How to use sheet Code Name in loop with sheet Name , VBA?

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

enter image description here

>Solution :

Perhaps the following:

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

Leave a Reply