we.tl/WejujzQFbZ -> put https before

Hi there,

You can download my Excel-file by using WeTransfer as I was not able to upload the file.

My problem is as following.
I have a hundred of arrays which are the inputs of a solver model. So a Solver model has to run a hundred times and each time the output has to be put in the corresponding array (column I and J).
I am totally new to VBA, so I don't have any idea what is technically possible.
Now I have tried to write a Solver code in a separate module, which is then called in the other module (within a loop).
When I execute this in VBA, I get error code 9: Subscript out of range.

Does anyone know how I can fix this?

Many thanks!!

Kind regards,

Lisa