There are two types of random number generators (RNG) in MS EXCEL :-

1) Rnd ---- Please ignore this, because it is a flawed/bad RNG (https://www.montecarloexceladdin.com/mersenne-twister-pseudorandom-number-generator-algorithm )

2) RAND() ----- May I know how to apply this RNG directly into Excel Macro VBA codes ? I would like to use the random numbers to do MONTE CARLO simulations.

Your reply would be much appreciated.

Cheers

James