Thread: kill worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
portroe portroe is offline
external usenet poster
 
Posts: 6
Default kill worksheets

I want to 'delete' all my worksheets after performing some operations on
the data,

The following code does NOT work sucessfully apparently due to the fact
that deleting all worksheets ends the Workbook, ! (error message)

Sub killWorksheets()
Dim W As Worksheet
For Each W In Worksheets
Worksheets(W.Name).Delete
Next
End Sub


Any tips most welcome,

thanks