Hello everyone.
I'm working on a spreadsheet that repeats the same calculations for a wide range of input values. The idea is that the user introduces a list of possible values for each input parameter, all possible combinations of those parameters are listed and the calculations are evaluated for all these possible combinations, then results are listed and filtered to see what the optimum set of parameters is. The problem I have with the macro I'm using is that it takes around 2 seconds to refresh the spreadsheet in order to evaluate each input set. Ideally, the spreadsheet should be able to evaluate around 400 combinations in an acceptable time and at 2 seconds per input it takes around 15 minutes, which is not practical at all. Here is the macro that I'm currently using.
Does anyone know anyway that I could improve this code to speed up the process?
Thank you very much in advance.
Bookmarks