Error in loop

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

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
 
Daniel problem was naming the sheets as a cell value.
There where duplicate names in the range
 
Back
Top