that worked!!! Thanks so much!! Have a great day!!

"Max" wrote:

"myssieh" wrote:
Thanks Max... I made these changes but Cell B:1 is still displaying a
number... I guess I can just hide the cell contents??

Col B is a helper col, which could be hidden away for neatness

Also, F9 works to change the random sample
but it also changes evertime they hit enter on
another cell, even a blank one. Is there a way to prevent this?

Try setting the calc mode to Manual
Click Tools Options Calculation tab
Check "Manual" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---