Thread: Deleting multiple sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kruncher Kruncher is offline
external usenet poster
  
Posts: 18
Default Deleting multiple sheets
Edit this to read:

If (wks.Name < "Product Names Data") Or (wks.Name < "Master
Product Sheet") Then
wks.Delete

and you should be OK.

Kruncher

Reply With QuoteReply With Quote