Error in loop

[Daniel Bonallack]

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

 

[Ron de Bruin]

Are you using Excel 97 Daniel ?

 

[Ron de Bruin]

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