Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Create macro to download access 2000 table to excel 2000 spreadsheet | Excel Programming | |||
Need help working with Sheet arrays in office 2000. | Excel Programming | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming |