Hey all, sorry to crosspost but I haven't gotten a response in the other forum.


I'm VERY new to Excel/VBA (know next to nothing)


I have a couple cells in a sheet that are depending on the results of a lot of previous cells, including RAND()s.

I want to refresh my sheet thousands/tens of thousands of times then create a distribution of the results found in these cells.

For example I refresh, and cell D10 for example can have different values of 5, 10, 0.5, 20, etc. And I'd like to run this several thousand times to get a good idea of what the distribution of results looks like.

It would be painstaking to do it manually, is there any way I can automate the process?

Thanks!!!


(Can't link previous post because I don't have enough posts yet)

Any help is greatly appreciated!