VBA - Help with Random Number Generator

[cosbys]

I have a set of data I am interested in doing calculations with depending on scenarios. One particular scenario I want to do is randomly generated numbers down the 'S' range/column that sum to 0.

I have accomplished summing the column to 0 via the last row being the difference to 0; however, I also want the last number to be within my range of random numbers (which is 0 to 300).

Also, this is a part I have yet to tackle, but how would you make it so these randomly generated numbers averaged to a certain number (7 in this case)?

Thanks for the help.

 

[pplstuff]

I realize this is not VBA, but have you looked at the randombetween() function? You can probably call it in VBA But I've never done that.

The average will should, on average, be the mid point of your min/max.