Find sheet name using wildcard

[mordrid]

I have a sheet in a workbook that may just be called cover and other times front cover, feb cover etc. I use VBA to find the sheet and insert a new one infront of it. Is there a way to look for the sheet by specifying a wildcard or text plus the word cover

Thanks

 

[Richard Schollar]

Hi

I think you'd need to loop thru all the sheets and test individually using Like:

For Each sht In ThisWorkbook.Worksheets
   If sht.Name Like "*Cover" Then  
      'take appropriate action (sheet ends with "cover")
   End If
Next sht