Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get random numbers from a certain range? Random numbers Excel Worksheet Functions 5 November 15th 09 11:08 PM
Unique RANDOM NUMBERS within specified range Matt D Francis Excel Worksheet Functions 5 July 15th 08 08:04 PM
how do you shuffle a range of numbers at random Ann Excel Worksheet Functions 1 August 30th 07 04:34 PM
How to select top six numbers from a of range of random numbers Jack M Taylor Excel Worksheet Functions 4 January 30th 07 09:18 PM
Generating Random Number from a set of numbers CalsLib Excel Discussion (Misc queries) 3 March 17th 06 04:27 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"