That is covered very well in the Excel help look up RAND

and I can't improve on that part. I could point you to a macro I use.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ddawg09" wrote in message
...

What if you only want random numbers within a given range. I need 100
numbers between 5.5 and 10.5 but I did the Randombetween function and
dragged it down but all it did was pretty much copy.


--
ddawg09
------------------------------------------------------------------------
ddawg09's Profile: http://www.excelforum.com/member.php...o&userid=31205
View this thread: http://www.excelforum.com/showthread...hreadid=521543