C
ChuckM
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
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