Try this:

http://www.tushar-mehta.com/excel/ne...ion/index.html

--
Regards

Juan Pablo González

"Job" wrote in message
...
Anyone know how to insert a random entry into a cell that is drawn from a
list or range of cells? For example, if I have AA,AB,AC,AD,AE,AF in A1:A6
and in A7 I wanted it to give me randomly one of the values from the
range.

Cheers,

Job