Wildcard characters inside a worksheet title in VBA

[crockwell]

I've tried searching for this, but I can't seem to find what I"m looking for...

I'm writing some VBA code where I reference different worksheets. Now, I need to be able to use a wildcard in the worksheet name. Does anyone know if this is possible?

For instance, I need to be able to call up the worksheet "0000-1" in one workbook and then use the same code for a different workbook to call up "0000-2"...etc.

I'd like to call it using...
Sheets("0000-#).Select

Excel doesn't like the #, the * or the ? wildcards.

Any help would be greatly appreciated. Thanks!

Christina

 

[CWatts]

Try this. It's pretty basic, but I made three sheets, titled "Temp", "0000-1" and "0000-2". I entered a value in A1 on the Temp sheet and ran my macro, it then passed that value in to the string for my Sheets() section below so the code would switch to the right sheet. The syntax should be easily modified for what you're looking to do.

Hope that helps.

Sub SheetWildcard()
    Sheets("0000-" & Sheets("Temp").Range("A1").Value).Select
End Sub

 

[cgcamal]

Hi crockwell,

Maybe the following example macro may help in some way.

Sub Select_Sheet()
Dim Sh As Worksheet

For Each Sh In Worksheets
    If Sh.Name Like "0000-[0-9]" Then
        Sheets(Sh.Name).Select
    End If
Next
End Sub

If the names are of the form "0000-#" you can use as above "0000-[0-9]" and if the names could have
one or more than one number like this "0000-##", you can use "0000-[0-9]*" as Regular Expression.

Hope this helps.

Regards.