Rand()

Hello

I have a bit of a complicated problem.

I have a column of returns I have to sort out by random numbers that I generate and calculated prices based on this information.

What I am supposed to do is calculate the mean of those prices based on the randomly sorted returns.

I can manage the code to do this once but I am required to call this macro a thousand times and output it on a different sheet. How do I get to do this thousand times where in I can get the macro to give me the mean price for each sorting in separate cells.

Also I need to switch off screen updating each time the random numbers are calculated on the spreadsheet and I try to put code to switch it off but each time I drag the cell containing RAND() to get random numbers for each cell i.e. the first cell number changes even when I put code to switch off screen updating.

I am attaching the spreadsheet.

Please help me out if you have any ideas or code that could help me.

Maybe like this:

Please Login or Register  to view this content.

Thanks Again. Thanks Again

masalagirl,

is there any reason why you edited and deleted your original question after you received an answer? If a post has received a reply you should not change it.

I've restored the original text.