Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to control sheet number when adding and deleting sheets?
I have some code that starts by deleting a certain number of sheets, then
after calculating stuff, it's creates a series of new sheets. The problem I have is that the new sheet object numbers always go up, even though the spreadsheet only counts about ten of them. After processing the code 1000 times, am I going to get error messages? (eg cannot create sheet32747) and how do I control this number? I add the sheet with Sheets.Add.Name = shtname thanks chuck |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct across mutliple sheets - deleting row in one sheet | Excel Discussion (Misc queries) | |||
ADDING/DELETING SHEET Without losing focus? | Excel Discussion (Misc queries) | |||
adding sheets based upon a template sheet | Excel Worksheet Functions | |||
Sequential number - adding and deleting rows | Excel Discussion (Misc queries) | |||
how to protect sheet from adding/deleting | Excel Discussion (Misc queries) |