Hi Deal or No Deal,

In a helper column, insert the RAND() function and then sort on the helper
column. Each time you press F9, the helper column values will change.


---
Regards,
Norman



"Deal or No Deal game simulation" <Deal or No Deal game
wrote in message
...
I have an array of 22 numbers from 1 to 22 in a column. By pressing F9 i
want
to be able to change their position randomly in the column. How can I do
this? In essence the numbers selected are not random number but what want
to
be random is the numbers position within the range of cells