Solutions Through Learning
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » EXCEL VBA - Introduction - Intermediate
Paul has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
I haven't been able to view my copy of the delegate model from the course I attended on 9/10 Aug in Bloomsbury Square.
Please could you send me a copy of the instructor's model? I didn't add any notes to my model - I wrote them down separately.
PS - I am currently using 2003, not 2007
Thanks
To generate a random number in Excel use the = RAND() function.
The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)
Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.
Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive
TrustScore
4.9
/ 5
2394 reviews
Connect with us:
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
