How can I generate a random number. I need to be able to input two numbers, the low and high ends then generate a random number between those two. I was trying something called "RANDBETWEEN(bottom,top)" that I found in help, but couldn't seem to get it working. Thanks
Random Number
- Thread starter RevJeff
- Start date
- Local time
- Today, 10:54
- Joined
- Feb 28, 2001
- Messages
- 30,495
Look up functions RND and RANDOMIZE.
How you do what you wanted is as follows, roughly...
Somewhere in the very early context of the thing that needs to do this, you need to execute a RANDOMIZE statement (this is VBA code...)
The function you describe, however, has to be limited in some ways. If your answer is, for example, required to be an integer or long integer, you have a conversion to perform, because RND only produces SINGLE random numbers (I think it is SINGLE).
But this would change if the numbers had to be ordinary integers or currency or some other data type.
How you do what you wanted is as follows, roughly...
Somewhere in the very early context of the thing that needs to do this, you need to execute a RANDOMIZE statement (this is VBA code...)
The function you describe, however, has to be limited in some ways. If your answer is, for example, required to be an integer or long integer, you have a conversion to perform, because RND only produces SINGLE random numbers (I think it is SINGLE).
Code:
Public Function loRndBetween( loLow as Long, loHigh as Long) as Long
loRndBetween = loLow + CLng( RND * CSng(LoHigh - loLow))
End FunctionBut this would change if the numbers had to be ordinary integers or currency or some other data type.
