Statistical Analysis and VBA

[Beowulfdl]

I have a program to take information from scan data for a machine and compile the information into one location for ease of use and for reporting purposes. I am now trying to take the information to the next level and include statistical analysis in my scan data. I have figured out how to actually have it compile the information, the problem I am running into is that if I have too much scan data, I get an error that the memory has run out. I am trying to put all of the information into one cell and having it all calculated in that cell. I believe if I can get the information put into an array of some kind where the statistical formulas can be calculated, it will make the report nice and tidy, but I'm not sure if my thinking is correct. I'm at a loss as to how to do this as well. This is the code I have so far:

Please Login or Register  to view this content.

I have put the sections in bold I am mainly concerned with.

I have included an example of what the final report would look like (except each row of data would have all of the headings, not just the top line).

[shg]

Please take a few minutes to read the forum rules, and then edit your post to add code tags.