Variable worksheet name

[camandab]

Hello,

I need to perform a certain action by determining if a sheet name contains a certain phrase. In this case, I'm looking for the word "Confidential". That word may appear anywhere in the sheet name so I wasn't sure how I could use the Mid function. Also, other words may come before or after it so I didn't have luck using wildcards like

If LCase(ws.Name) Like "*Confidential" Then...

Just need some direction to get this code to recognize the sheet by whether or not the sheet contains the word "Confidential".

Thank you.

 

[hrithik]

If you are comparing with lower case sheet name, shouldn't it be "*confidential"?

 

[camandab]

Oh my goodness. I'm embarrassed...

Thanks for pointing out the obvious!