Max No of Sheets?

I have a macro which changes a worksheet based on each record from another sheet, it then copies the worksheet. I.e. a new sheet is created for each record simpy with...

Please Login or Register  to view this content.

This works fine but only copies about 30 sheets before the macro stops and says 'copy method of worksheet class failed'. At this point, even if I delete the 30 sheets and manually try and copy the sheet I am unable to.

Is there a maximum number of sheets that I can have?
Every time I copy a named range is being created, is it something to do with a limited number of names?
Other?

Grateful for any advice

Look in the help files for excel limits, although 30 sheets is not the limit. I think it basically depends on computer memory

It does seem to helped if I add a sheet and then copy and paste, even though I end up with the same information on the sheets at the end of the day.
When deleting things like names for ranges and control buttons on the page I think Excel must somehow keeps those things in memory even though they are gone?