VBA Like Operator

[danbrawl93]

Hello,

I have been using the Like operator in VBA to activate sheets if they have a given start to their name. See example below:

Sheet name = "AI. 1234567"
Identifying start to name = "AI."

The code for this would be as follows:

For Each sh In Worksheets
If sh.name Like "AI.*" Then
sh.Activate
' Do stuff
End If
Next sh

However, I now have an issue due to a sheet being named in the following format, which is also activated: "MA. Example"

I thought my code above would simply activate sheets beginning, and only beginning, with "AI." with the * providing a wildcard for the rest of the sheet name. Clearly I am mistaken, so could somebody please explain how the * works and why the undesired sheet is being activated? If an alternative can be used to activate sheets with a specific start to its name ("AI." in this case) then please let me know, as this is the desired effect.

Many, many thanks!

Dan

 

[MrKowz]

Try parsing out the left 3 characters of the sheet name using the LEFT() function and using that as the comparison.

For Each sh In Worksheets
    If Left(sh.Name, 3) = "AI." Then
        sh.Activate
        ' Do stuff
    End If
Next sh

 

[Fluff]

I thought my code above would simply activate sheets beginning, and only beginning, with "AI." with the * providing a wildcard for the rest of the sheet name.

I would agree with you, and having tested your code it does just that.
An alternative would be

If Left(sh.Name, 3) = "AI." Then

 

[danbrawl93]

Just tried the code again and it no longer opens the page in the naming format "MA. Example. Absolutely no idea why it was happening before, just a case of closing and re-opening Excel... Thanks for your alternative suggestions, they make sense

 

[danbrawl93]

Update: My code was opening the active sheet, which was the "MA. Example" one - so I was wrong altogether haha