Check if an active sheet belongs to a named list

[girapas]

In a workbook there are many sheets. I've define the name "SpecialSheets" with some of them, say Sheet1, Sheet2, Sheet3.
Which is the code to check if an active sheet name belongs to SpecialSheets list?
thanks in advance...

 

[VoG]

Try like this

If IsNumeric(Application.Match(ActiveSheet.Name, Range("SpecialSheets"), 0)) Then MsgBox "Match found"

 

[girapas]

Great! Thank you