I'm creating new sheets by copying a template sheet.
My loop requires that Excel make about 90 sheets and place
them at the end. After the 15th however, it seems to run
out of memory and just give me an error. Even when I
switch to Excel, I can't even manually copy a sheet:

This is my copy line to be repeated 90 times.
Sheets("Template").Copy After:=Sheets(Sheets.Count)

Any ideas?

Thanks
Daniel

Are you using Excel 97 Daniel ?


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Daniel Bonallack" wrote in message ...
I'm creating new sheets by copying a template sheet.
My loop requires that Excel make about 90 sheets and place
them at the end. After the 15th however, it seems to run
out of memory and just give me an error. Even when I
switch to Excel, I can't even manually copy a sheet:

This is my copy line to be repeated 90 times.
Sheets("Template").Copy After:=Sheets(Sheets.Count)

Any ideas?

Thanks
Daniel

Daniel problem was naming the sheets as a cell value.
There where duplicate names in the range

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Are you using Excel 97 Daniel ?


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Daniel Bonallack" wrote in message ...
I'm creating new sheets by copying a template sheet.
My loop requires that Excel make about 90 sheets and place
them at the end. After the 15th however, it seems to run
out of memory and just give me an error. Even when I
switch to Excel, I can't even manually copy a sheet:

This is my copy line to be repeated 90 times.
Sheets("Template").Copy After:=Sheets(Sheets.Count)

Any ideas?

Thanks
Daniel