Copy cell value to another cell with variable number of iterations

[WeirnetherlandsBart]

Hello,

Attached file column A shows 24 values which are entered by the user. Cell E3 calculates a random value every time there is a change in the worksheet. This is an array function. What I want is that every random value is calculated as much as the number of iterations entered in Cell E1. Every random value must be placed from Cell E3 in column G, starting with Cell G2. Following random value calculated from Cell E3 must be placed in Cell G3 etc. This as much as the number of iterations enterd by the user. I tried a couple of times in Vba, but I need some advise! Here is a start from my code.

Thanks in advance!

Cheers, Bart

Please Login or Register  to view this content.

[sktneer]

You may try this to see if you get the desired output.

Please Login or Register  to view this content.

[WeirnetherlandsBart]

Thanks! That was what I needed!!!!