dim ws as worksheet
for each ws in Worksheets




On 5 May, 17:44, 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?