Excel 2000 VBA Arrays

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Wildcard in Excel array formula 0
Filling an Array Quickly 4
Filling an Array Quickly 13
Data storage in arrays 4
quickest way to find last "used" row in a 2D array? (repost) 3
Importing Files into Excel using VBA 1
Assembling large "array" 3
what is array size limit in VBA? 1

Back
Top