Finding Sheet Names starting with #

[stuartgb100]

Hi,

I can find sheetnames starting with # using
If ws.Name Like "#*" Then
but
It also finds sheetnames starting with ##

How can I exclude the ## sheets, please ?

Thanks.

 

[Edgar_]

if you're using Like, I suppose this should work:
If ws.Name Like "#*" And Not ws.Name Like "##*" Then

But I would likely prefer to use this:
If Left(ws.Name, 1) = "#" And Left(ws.Name, 2) <> "##" Then

 

[stuartgb100]

Many thanks.
Could you explain your reason for the preference, please ?
Regards.

 

[Edgar_]

You mentioned this:

I can find sheetnames starting with # using
If ws.Name Like "#*" Then

That's why I said you could use
If ws.Name Like "#*" And Not ws.Name Like "##*" Then

But, as far as I recall, you would have to escape the # character, like this:
If ws.Name Like "[#]*" And Not ws.Name Like "[#][#]*" Then
Because the # symbol is a wildcard for numbers.

So, in order to avoid having conflicts with whatever you have, I suggested the Left method, which does care about wildcards.

 

[stuartgb100]

Thanks.
Didn't know that # could be used like that.
Regards.