Help with a copy function
I don't know of any quick and easy way of deleting sheets like that - I don't
think you can use wildcard characters with collection objects.
If I was you I would just loop through all the sheets and delete the ones
you want, something like......
Dim sht as sheet
for each sht in worksheets
if left(sheet.name,5) = "name-" then sht.delete
next
|