| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clearing VBA worksheet names
I have a VBA program that, when executed, deletes all the worksheets in a workbook and creates new ones. Each time I execute this, the worksheet names ("Sheet1", "Sheet2", etc) aren't cleared...that is, if Sheet1 through Sheet25 are deleted, the new sheets start at Sheet26...even if I close Excel and reopen the workbook. How do I get the newly created sheets to restart at Sheet1?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
| Clear a worksheet without clearing formulas? | Excel Discussion (Misc queries) | |||
| Worksheet clearing Macros? | Excel Discussion (Misc queries) | |||
| Exel VBA - Clearing clipboard, area names | Excel Programming | |||
| Clearing Dropdowns In A Worksheet | Excel Programming | |||
Threaded Mode
