| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Random number macro
I would like to create an Excel macro which will put a series of random
integers (leaving values not the formulas) in cells in a column. It should start in the currently selected cell and fill downwards until it has covered the number of cells given by the number in, say, cell P1. The random integers should be between 1 and the number in cell P2 (inclusive). Can anyone help please? Many thanks, V |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Addding a Random number to a fixed number..... | Excel Discussion (Misc queries) | |||
| How can I match a random number with closest number from sequence? | Excel Worksheet Functions | |||
| Random number Macro | Excel Discussion (Misc queries) | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
![Victor Delta[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
