How Do I Compare A Sheet Name To A Wildcard Char In A Macro?

[bpensa]

I am trying to compare a sheet name in a workbook to a wildcard as I loop through multiple sheets. Here is the code I am trying to fix:

If wsname = "X*" Then

 

[Norie]

You could try Like instead of =.

 

[mikerickson]

Use the Like comparison

If wsname Like "X*" Then

 

[bpensa]

That worked thanks.