I think I grasp that, but I am trying to repeat your testing
results and don't see how you are getting the results you claimed
in the first message.

For Each Value In new_array
Debug.Print Value
Next Value

When I add the following to the LogArray function  (just before
it ends), I get this in the immediate window (CTRL+G will reveal it),
so I don't understand why you are only seeing the first value, four
times.

0.181843587944773
0.301029995663981
0.397940008672038
0.474216264076255