| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Numbers
Does any have any code for generating random numbers and
then input them in a cell? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Random Numbers
Ed,
You can use the Rnd function to return a random number. For example, Dim Rng As Range For Each Rng In Range("A1:A10") Rng.Value = Rnd Next Rng -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ed" wrote in message ... Does any have any code for generating random numbers and then input them in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
| How to select top six numbers from a of range of random numbers | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Linear Mode
