| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete range of Worksheets
I am working on a scheduling system using macros in Excel. I use 26
commandbuttons to goto their respective payperiod (ie worksheet). Since I am in a testing stage, I created a macro (executed by clicking a commandbutton), that will reset everything so I can start from scratch again. During this reset, I need the macro to delete the 26 worksheets, which were all named differently, based on the payperiod it represents. How do I delete those 26 worksheets? Example of worksheet names: Jan 1 - Jan 13 Jan 15 - Jan 28 Jan 29 - Feb 11 Thanks for your help! Les |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
| Looping through selected worksheets and delete a range (e.g., A2:D15) | Excel Programming | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
| Range.Delete and Range.Resize.Name performance issues | Excel Programming | |||
Threaded Mode
