Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a spreadsheet with many rows and columns of data. I have a program that searches the data line by line and performs various calculations. My problem is that the code takes approximately 15 minutes to run due to the number of iterations and searches. Rather than restructure the code completely, I was wondering if initially saving the data to a large array and then performing the calculations and searches on the array rather than the spreadsheet itself would reduce my calculation time. If so, this step would be much easier than restructuring the code. Thank you in advance for your thoughts. -Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Searching through text - Speed issue | Excel Programming | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
sumproduct, arrays affecting speed | Excel Worksheet Functions | |||
Searching for VB Code to Link to Program | Excel Programming | |||
Searching / Calculating Multi-Dem Arrays | Excel Programming |