You could use something like this...

Dim sht As Worksheet
For Each sht In ActiveWorkbook.Sheets
If Left(sht.Name, 9) = "ScoreCard" Then
With sht
'do something
End With
End If
Next sht

Hope this helps,

Hutch

"Bishop" wrote:

How can I use a wildcard in a With Sheets statement? I have written a macro
that works on sheet ScoreCard. However, during the export process if the end
user saves the workbook rather than open it ScoreCard is changed to
ScoreCard.Bob or ScoreCard.Alice. I need to do something like this to make
the macro work

With Sheets("ScoreCard*")

but that doesn't work. Ideas?