Max,
Any entry, number or text (any length), as the second argument does that...
=scramble(D6,x)

Regards,
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html




"Max"
wrote in message
"Jim Cone" wrote:
.. Any entry there causes the function
to scramble each time the sheet is calculated.

Jim, many thanks for your UDF ! Is there a way to force the UDF to recalc
whenever I press F9? Most of the time, the source data would be static, but
I'd like to re-scramble.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---