Excel For Next Loops and Not Reponding State

[UCNumber10]

Hello,

I am working for next loops to run through a numerical integration and I am running into a problem with excel not responding. Even through excel is not responding, the macro still completes and posts the correct solution. Excel returns to a functional state near the end of the macro completion. I linked a progress bar to outer loop to see where it is getting hung up. Excel stops responding when the progress bar reaches 16-18%, and then hangs at this % until the macro completes. The calculations are completed accurately and the macro will run to completion. Everything works other than the temporary not responding state.

There are three for next loops within an outer for next loop.

Array2(501, 3) As Double
Array3(501, 5) As Double
Array4(501, 3) As Double
Array5(101, 3) As Double

For i=1 to 101
For k = 1 to 501
Array2(k, 1) = Calculation 1
Array2(k, 2) = Calculation 2
Array2(k, 3) = Calculation 3
Next

For k = 1 to 501
Array3(k, 1) = Calculation 1
Array3(k, 2) = Calculation 2
Array3(k, 3) = Calculation 3
Array3(k, 4) = Calculation 4
Array3(k, 5) = Calculation 5
Next

For k = 1 to 501
Array4(k, 1) = Calculation 1
Array4(k, 2) = Calculation 2
Array4(k, 3) = Calculation 3
Next

Array5(i, 1) = Calculation 1 (based on outputs from previous 3 loops)
Array5(i, 2) = Calculation 2 (based on outputs from previous 3 loops)
Array5(i, 3) = Calculation 3 (based on outputs from previous 3 loops)

Next


Thanks

[UCNumber10]

One more thing.....the calculation steps user a UDF linear interpolation function.....If i remove this step, then the macro completes much faster without getting stuck in the not responding state.

Is there a better place to integrate this function? Directly into the macro?