vba - generating a random number between 1 and 20

Question

The code I previously used was

Randomvariable = 1 + Int((20 - 1 + 1) * Rnd())

I'm a bit concerned it wasn't right because the format I'm seeing online in guides is

random_number = Int(20 * Rnd) + 1

Was my way equivalent to this?

Answer 1

Have a read about the Rnd() function

The general formula is

Int ((upperbound - lowerbound + 1) * Rnd + lowerbound)

Therefore if you want to generate random numbers between 1 and 20 use

Int((20 - 1 + 1 ) * Rnd + 1)