View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Blue Aardvark Blue Aardvark is offline
external usenet poster
 
Posts: 31
Default 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