Excel 2000 VBA Arrays
 

Want to run summary statistics on a large data array. Excel won't process
more than ~ 5400 pieces of data. Would like to understand what the problem
is. Can you help?
Example: Data(65000) is a single column data array
Stats(8) is an eight line array to store statistical results
Stats(1) = application.worksheetfunction.average(Data())

Works fine if Data is less than ~ 5400. Won't work for larer data sets
Thanks!!

Excel 2000 VBA Arrays
 

This is a known limit of using variant in older versions
of excel. For more info see:
http://support.microsoft.com/default...b;en-us;177991
XL: Limitations of Passing Arrays to Excel Using Automation




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


chasjohn02 wrote :

Want to run summary statistics on a large data array. Excel won't
process more than ~ 5400 pieces of data. Would like to understand
what the problem is. Can you help?
Example: Data(65000) is a single column data array
Stats(8) is an eight line array to store statistical results
Stats(1) = application.worksheetfunction.average(Data())

Works fine if Data is less than ~ 5400. Won't work for larer data sets
Thanks!!