| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking for text in Sheet Name
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking for text in Sheet Name
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking for text in Sheet Name
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking if Sheet Exists? | Excel Discussion (Misc queries) | |||
| Checking to see a sheet of the same name exsists | Excel Programming | |||
| Checking if sheet is visible | Excel Discussion (Misc queries) | |||
| Checking for existence of value in another sheet | Excel Programming | |||
| Checking to see if a sheet is open | Excel Programming | |||
Linear Mode
