Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have table of raw data (1000 rows and 150 columns) stored in a
worksheet. I'd like to copy them all into a 2-dimension array then do all the calculation with this array (not the raw data on the sheet). The calculated result will be in another array (that has the same size or bigger). This array will be copied back into another sheet (result sheet). The problem is that it runs really slow when it calculates values for every element in result array. Please anyone can tell me how to speed up or better solution for this issue. All the best *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Speed of array formula | Excel Worksheet Functions | |||
charting performance speed | Charts and Charting in Excel | |||
Excel Speed Performance help | Excel Discussion (Misc queries) | |||
Worksheet speed with array formula | Excel Discussion (Misc queries) | |||
VBA - speed up macro, working with array? | Excel Programming |