| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete all sheets except the active one...?
"Delete all sheets except the active one...?"
How can I do that in VBA, anyone? thx Robin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete all sheets except the active one...?
Try this...
dim wks as worksheet application.displayalerts = false for each wks in worksheets if wks.name < activesheet.name then wks.delete next wks application.displayalerts = true -- HTH... Jim Thomlinson "derobin" wrote: "Delete all sheets except the active one...?" How can I do that in VBA, anyone? thx Robin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
| Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Hybrid Mode
