Hello Jim,

To understand what is happening here you have to remember that this a
collection. All collections share common attributes like Add, Count,
Item, and Remove methods. They also contain a "Key" and "Value". The
key is the system's index into the table of Values.

The Chart collection doesn't allow you to set the "Key" like you can
with standard Collection object. If it did you could reuse the numbers
you have already deleted. The only way to reset the Chart collection is
to remove all objects from it and re-open the workbook.

As far as the limit goes, I don't think that will be an issue. If the
index is only an integer value, that would give 65536 charts. If if it
were a Long Integer you could have up 16.7 million. But the size of the
chart and it's complexity are more of an issue. Graphics use lots of
memory resources. Add to that what programs are loaded , the amount of
memory available, etc. and it's almost impossible to give an exact
number of charts that the system can handle at once.

Hope this helps you understand a lottle more about what is happening.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=509138