Checking for text in Sheet Name

[Barb Reinhardt]

I am wanting to check for a specific grouping of text in the sheet name using
something similar to the SEARCH function. Let's say, for example, I want to
find if "1" is present in the sheet name. How would I code that?

Thanks,
Barb Reinhardt

[Die_Another_Day]

If InStr(1,ActiveSheet.Name,"1") > 0 Then
'1 is in the name
Else
'1 is not in the name
End If

HTH

Die_Another_Day

Barb Reinhardt wrote:
> I am wanting to check for a specific grouping of text in the sheet name using
> something similar to the SEARCH function. Let's say, for example, I want to
> find if "1" is present in the sheet name. How would I code that?
>
> Thanks,
> Barb Reinhardt

[Dave Peterson]

Check out VBA's InStr().



Barb Reinhardt wrote:
>
> I am wanting to check for a specific grouping of text in the sheet name using
> something similar to the SEARCH function. Let's say, for example, I want to
> find if "1" is present in the sheet name. How would I code that?
>
> Thanks,
> Barb Reinhardt

--

Dave Peterson

[Stefi]

Hi Barb,

x = InStr(1, ActiveSheet.Name, "1")
gives you the place of "1" in sheet name or 0 if "1" is not present.

Regards,
Stefi

„Barb Reinhardt” ezt �*rta:

> I am wanting to check for a specific grouping of text in the sheet name using
> something similar to the SEARCH function. Let's say, for example, I want to
> find if "1" is present in the sheet name. How would I code that?
>
> Thanks,
> Barb Reinhardt