44 sheets doesn't sound like it would consume a lot of RAM. How much memory
do you have on your machine?

Dave
--
Brevity is the soul of wit.


"Bug289" wrote:

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?