Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run macro on all sheets | Excel Worksheet Functions | |||
Use same macro on 2 sheets? | Excel Programming | |||
sheets macro | Excel Programming | |||
"With Sheets" Issue - macro on one sheet to affect hidden rows on other sheets | Excel Programming | |||
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named? | Excel Programming |