The formulas is [=int(rand()*(100-1)+1)] in cells a1:e1.
Then cells a2:a6, cell a2=a1, a3=b1, a4=c1 etc...

I would like to sort the results in dec. order in cells a2:a6 after
each recalc.

The problem I have after the sort is a result of "REF#" Can anybody
help?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=471550