Checking for text in Sheet Name
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
|