Hi Philippe,

Are you sure that you really want possibly repeated values
for random scheduling? If not, enter the UniqRandInt()
from http://www.sulprobil.com/html/uniqrandint.html and
delete the line Application.volatile.

If you select 7 adjacent cells, enter =UniqRandInt(7) with
CTRL+SHIFT+ENTER (array formula) these values will stay
until you edit (and "fire" with CTRL+SHIFT+ENTER) these
cells again.

Regards,
Bernd