Thread: Delete worksheets
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
andym andym is offline
external usenet poster
  
Posts: 1
Default Delete worksheets

Sorry, one more thing. How can I adapt the code to delete everythin
other than Sheets1 and 2? I have tried
If ws.Name < "Sheet1" Or "Sheet2" Then ws.Delete but this doesn'
work.

Thank

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Reply With QuoteReply With Quote