Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to kill an ActiveX object | Excel Discussion (Misc queries) | |||
Kill Macro | Excel Discussion (Misc queries) | |||
On time kill | Excel Discussion (Misc queries) | |||
AutoFill KILL | Excel Programming | |||
how to kill excel using a vbscript | Excel Programming |