In case you have the need, the free Special Randoms workbook;
Download here... http://excelusergroup.org/media/

Can generate:
1. Randoms that total.
2. Randoms that average.
3. Unique random numbers
4. Random text or numbers of a specified length

Constrained by Set Size, Min/Max value or length.
--
Jim Cone
Portland, Oregon USA




"Victor Delta"
wrote in message
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