ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Random Number between a Range of Numbers (https://www.excelbanter.com/excel-programming/434501-random-number-between-range-numbers.html)

Philosophaie

Random Number between a Range of Numbers
 
I have a range of numbers say from 1 to 1000. I want to have picked a random
number from that range and nothing else each time click a button, etc.

Jacob Skaria

Random Number between a Range of Numbers
 
Try
Msgbox Int(1000 * Rnd + 1)

If this post helps click Yes
---------------
Jacob Skaria


"Philosophaie" wrote:

I have a range of numbers say from 1 to 1000. I want to have picked a random
number from that range and nothing else each time click a button, etc.



All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com