Deleting many sheets with similar names

Hi there,

I was just curious if I could delete a large number of sheets, all with similar names in a single for loop. I want to be able to delete sheets like "Sheet13" and "Sheet45". Is there a character or symbol that means any number?

For Each sh In ActiveWorkbook.Worksheets
ActiveWorkbook.sheets("Sheet" & 'symbol?').Delete
Next sh

If you have another way of doing it that would also be very helpfull.

Thanks alot!

The only thing that the differant sheets have in common are the name "Sheet". I want to be able to delete any worksheet with the name "Sheet", regardless of the number.

Thanks for the fast reply!

Try this:

Please Login or Register  to view this content.

ska

Awesome guys!

Thanks VBANoob and ska, both of those work great, I really appreciate it.