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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addings sheets using Macro
On Jan 9, 11:47*am, rob wrote:
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? Hmm. Works fine for me in 2003. What version of excel are you running? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addings sheets using Macro
S. I'm running 2003
"S Davis" wrote: On Jan 9, 11:47 am, rob wrote: 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? Hmm. Works fine for me in 2003. What version of excel are you running? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addings sheets using Macro
Hi,
It may be you are running into the cell format issue. If your copying a template sheet which has alot of formatting on it, you may be hitting the format limit. You could try removing alot of the formatting from the template and test again and see if you get more than 14 sheets. Cheers, Tony. "rob" wrote: S. I'm running 2003 "S Davis" wrote: On Jan 9, 11:47 am, rob wrote: 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? Hmm. Works fine for me in 2003. What version of excel are you running? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addings sheets using Macro
Indeed, if a remove other sheets etc and data, I can run unto 79 sheets.
I need the formatting. is there a work around different from .save and .open ( resets somewhere the memory, but I cannot save the document at that moment) "Tony Zappal" wrote: Hi, It may be you are running into the cell format issue. If your copying a template sheet which has alot of formatting on it, you may be hitting the format limit. You could try removing alot of the formatting from the template and test again and see if you get more than 14 sheets. Cheers, Tony. "rob" wrote: S. I'm running 2003 "S Davis" wrote: On Jan 9, 11:47 am, rob wrote: 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? Hmm. Works fine for me in 2003. What version of excel are you running? |
Reply |
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 |