Forum Discussion
VBA Random Number
Hi All, I have created a Random Number Generator using the code below Private Sub CommandButton1_Click() Range("d2") = WorksheetFunction.RandBetween(-2, 2) Range("d3") = WorksheetFunction.R...
You may consider the following:
Range("F1") = WorksheetFunction.RandBetween(-2,2) ' The first random number
k = Range("F1")
Range("F2") = WorkhseetFunction.RandBetween (k,2)
' The second random number which lower bound depends on the previous random numberHop it helps.
You may consider the following:
Range("F1") = WorksheetFunction.RandBetween(-2,2) ' The first random number
k = Range("F1")
Range("F2") = WorkhseetFunction.RandBetween (k,2)
' The second random number which lower bound depends on the previous random number
Hop it helps.
Thank you I will give it a try :)
