| This Excel function is passed 2 parameters starting and ending and returns a pseudorandom integer between the start and the end.
Enter below in an Excel cell =randbetween(1,10) Returns a random number between 1 and 10. To call in VBA: a = [=randbetween(1,10)] To use variables Range("A1") = 1 Range("A2") = 10 a = [=randbetween(A1,A2)] debug.print a To use VBA variables first_nbr = 1 last_nbr = 10 a = application.evaluate("randbetween(" & first_nbr & "," & last_nbr & ")") |