WorksheetFunction.RandBetween (Excel)

Returns a random integer number between the numbers that you specify. A new random integer number is returned every time the worksheet is calculated.

RandBetween (Arg1, Arg2)

Dim dblRandBetween As Double
dblRandBetween = WorksheetFunction.RandBetween(Arg1:=, Arg2:=)

Arguments

Arg1 - Bottom - the smallest integer RandBetween will return

Arg2 - Top - the largest integer RandBetween will return