Runtime Error -2147417848 (80010108) The Object Invoked Has Disconnected from Its Cli

Hello,

I have a rather compex macro I've been developing. It is used to perform some statistical analysis on tesults from a materials testing program. The macro is designed to perform goodness of fit tests on the results to detemine an appropriate probability distribution that best describes the data. All the test results are stored in a single worksheet in an Excel workbook.

The macro loops through the full set and collects the results into an array according to a set of grouping parameters. The array is then output to a new workbook where the goodness of fit tests is conducted and probability plots are generated. I'm examinining the goodness of fit using both Normal and Lognormal probability distributions. To save space in my thesis, I want to put two probability plots (normal and lognormal) for each material roperty on the same chart sheet. The procedure does this by first generating each probability plot on separatechart sheets then moving them both onto the same sheet.

Everything was working fine up until about an hour ago when I started getting a Runtime Error -2147417848 (80010108), "The Object Invoked Has Disconnected from Its Clients". This error does not occur until several sets of output workbooks have been generated. It happens at the line of code that tells Excel to move the two probability plots onto the same sheet. Has anyone any possible explanations?

Earlier in the day, I had the error about exceeding the maximum allowable number of font sizes that can be used in a single workbook so I modified my registry to disable the AutoScale fonts option when plotting charts. Could this have contributed to the latest problem? Also, with the crrent set of results, the macro generates ten separate output workbooks and takes about five minutes to run. To save time, I frequently use Excel 2007 to open up the completed output workbooks to see how they're working out while the macro is still running and generating outputs in Excel 2000. Could this be contributing to the problem? If so, how come this did not happen till now?

If you need any post parts of the code, please don't hesitate to ask

http://support.microsoft.com/kb/215573