Addings sheets using Macro
I have created a macro to add a number of sheets.
But every time when I want to add the 14th sheet, I receive a 1004 error.
The macro is very simple:
for i = 1 to 20
Sheets("Default").Copy befo=Sheets(2)
next i
In order to do so, I copy a template sheet.
What is wrong?
It looks like a stack overflow?
Do I have to reset some parameters?
I cannot even add a sheet manually after this error.
When I save and re-open I can again add sheets upto 14.
So it is not the total number of sheets that gives me the problem.
Any help?
|