How are you adding the sheet? There is a resource problem with Sheets.Copy
in VBA.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Bug289" wrote in message
...
I have a weekly programming programme in excel that adds a new worksheet
for
each week. Unfortunately it only works up to 44weeks and then hits a
runtime
error. On another computer it only gets to 43weeks. Reading Excel help I
understand the number of worksheets is limited by memory.

Is there any chance that this can be overcome to allow more sheets to be
added?