Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

how to generate a rondom number btween two ranges?

A range is an area on a spreadsheet. Do you mean between two numeric values?

Have a look at the RANDBETWEEN function...............

=rand()........................................

Keep in mind that the VBA Rnd() function has a cycle of just 16.7

million random numbers. (At least, that was the case in Excel

2002).

If you need more than 16.7 million random numbers for an application,

as I did, you will need to create the numbers with another

algorithm. I settled on the Mersenne Twister algorithm, which,

thankfully, is pretty efficient!

See: www.math.sci.hiroshima-u.ac.jp/~m-mat/MT/emt.html

Didn't find what you were looking for?
Find more on how to generate a rondom number btween two ranges
Or get search suggestion and latest updates.

Related Topics:

- highlight a range using a named range
- generating random numbers
- counting the frequency of randomly generated real number
- find the number of working days (monday to firday) between two give
- Addition of two numbers
- Change every second column to a negative number
- Whether the number is the power of two or not.
- Converting a "Stringed" Number to a Number
- Converting a "Stringed" Number to a Number
- type casting /converting seconds to a days hours minutes seconds
- Getting a range of values
- subscript out of range
- Mimi's range selection macro
- Finding duplicates from an excel range and coloring them automatically
- Finding duplicates in a range
- Insert Rows, based on data in range, using VBA
- Array and Range
- Create Dynamic Ranges in VB
- Create Dynamic Ranges in VB
- Create Dynamic Ranges with VB, clue given
- loop through a range name
- Help needed with Range Copy and Paste
- Summing a range of variable size
- determining when a range is invalid
- Formula using range name in VBA code