By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

=Randbetween( )

=randbetween(1,100)

Returns a random integer between 1 and 100, ie 1, 2, 3, ... 100

=randbetween(0,1)

returns a random integer (no fraction) between 0 or 1

randbetween is passed two parameters.

start and end which can be values or cell references.

It's really pseudo-random

Use

Application.Evalutate("=randbetween(1,100)") ' in VBA

[=randbetween(1,100)] ' in vbq

Errors

Error 2029 - I spelled "between" as "betweeen" (3 e's ) "betweeen

Error 2015